sweetbuttercup
asked on
MS ACCESS Form field with multiple parts.
I currently have a form that collects demographics from a member and stores the data in a db.
The field address is currently a text box. Is it possible to capture the field “Address” from several fields to split the address: Text field for house number + drop down to select “N” , “S”, “SW” “NW”…etc + text field for street name/number + Drop down for “AVE”, “ST”, “CT”, “RD”..etc. Then combine all 4 parts into a single db column “Address”??
The field address is currently a text box. Is it possible to capture the field “Address” from several fields to split the address: Text field for house number + drop down to select “N” , “S”, “SW” “NW”…etc + text field for street name/number + Drop down for “AVE”, “ST”, “CT”, “RD”..etc. Then combine all 4 parts into a single db column “Address”??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A single textbox with the *Entire* Address?
Is this bound to a single "Address" field?
If so then you will have to first create all the individual fields, then split this existing field into each of these new fields.
Can you post some generic data from your table?