Address Field

[James Ivey]

Access Newbie here.

I'm creating a membership database that has both USA members as well as
foreign members. Some of the foreign addresses have several more lines of
info than a standard USA address.

Should I just have one Address field? or multiple? (like Address_1,
Address_2, Address_3, etc)

Thanks!

James Ivey

 

[Steve Schapel]

James,

I think it depends on the nature of the application, and how the address
data is going to be used. In particular, will there ever be the need to
sort or group the records according to Country? How about City? If the
answer is yes, these need to be in separate fields. If not, I normally
find it easiest to just have one address field. In which case, users
have to be taught to use Ctrl+Enter to go to a new line in the Address
textbox on their forms.

 

[James Ivey]

Thanks a bunch Steve. The Ctrl+Enter is exactly what I am after.

Best regards,
James

 

[fredg]

Thanks a bunch Steve. The Ctrl+Enter is exactly what I am after.

Best regards,
James

Or simply set the Address control's EnterKeyBehavior property to New
Line in Field.

 

[James Ivey]

Good one Fred. Thanks!

James

Or simply set the Address control's EnterKeyBehavior property to New
Line in Field.