Help with TextBox

[hullstorage]

Hi all,

i am looking at changing my address fields with 1 list box
the problem i think i am going to face is that these fields
are automatically filled in from results from a query
but i need the address to have a couple of blank fields for the house number
any ideas

 

[dkinley]

I usually have two address fields for contact information when I am tracking things. One for the street address and another for apartment/suite number, etc.

So pretending my first field is called Add1 (the street info) and my second is Add2 (any other info), in my reports/envelopes I use the following to concantenate the address into one line:

=IIf([Add2]=Null,[Add1] & ", " & [Add2],[Add1])

This will show only Add1 if there is no entry into Add2, but will place a comma between the two if there is an Add2 entry.

-dK