We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

MS ACCESS Form field with multiple parts.

sweetbuttercup
on
Medium Priority
358 Views
Last Modified: 2012-06-21
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”??
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
<The field address is currently a text box.>
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?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.