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

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.

--
Steve Schapel, Microsoft Access MVP

James Ivey wrote:
> 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
>
>

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

Best regards,
James


"Steve Schapel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> James Ivey wrote:
>> 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

On Tue, 17 Jul 2007 22:17:22 -0500, James Ivey wrote:

> Thanks a bunch Steve. The Ctrl+Enter is exactly what I am after.
>
> Best regards,
> James
>
> "Steve Schapel" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.
>>
>> --
>> Steve Schapel, Microsoft Access MVP
>>
>> James Ivey wrote:
>>> 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

Or simply set the Address control's EnterKeyBehavior property to New
Line in Field.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Good one Fred. Thanks!

James


"fredg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Tue, 17 Jul 2007 22:17:22 -0500, James Ivey wrote:
>
>> Thanks a bunch Steve. The Ctrl+Enter is exactly what I am after.
>>
>> Best regards,
>> James
>>
>> "Steve Schapel" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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.
>>>
>>> --
>>> Steve Schapel, Microsoft Access MVP
>>>
>>> James Ivey wrote:
>>>> 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
>
> Or simply set the Address control's EnterKeyBehavior property to New
> Line in Field.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail