Text boxes linked to the same field

[a02227]

Is it possible to link multiple text boxes to the same field in a table

For example allowing three boxes for the entry of an address however it is all copied into the one field in the database?

Thanks for the help

 

[Pat Hartman]

If there are three parts to an address, there should be three fields in the table.

You could only do this with unbound controls. The current event would need to split the source field into three parts and the you would need to assemble the three unbound fields into one when the record is saved. Working with unbound fields adds a bit of a challange to Access. I strongly recommend fixing the table rather than trying to code around the problem.

 

[Bat17]

It is a lot easier to put three seperate fields from a table into one field for display/printing than to do the reverse

Peter

 

[ansentry]

Put this in a new column of your query, change the names to suit.

FullDetails: [[COLOR="Blue"]CustomerName[/COLOR]] & Chr(13) & Chr(10) & [[COLOR="Blue"]cusStreet[/COLOR]] & Chr(13) & Chr(10) & [[COLOR="Blue"]cusCity[/COLOR]] & " " & [[COLOR="Blue"]cusState[/COLOR]] & " " & [[COLOR="Blue"]cusPostCode[/COLOR]]

You can then use this in forms and reports, very good for printing labels