Any problem with putting address in Memo Field ?

[MyEmailList]

We don't need to sort by city, state, zip, etc.

Is there any reason we can't put the address in a memo field... so it
can be put on 3 or 4 lines and printed on an envelope if needed?

Reason? Requires only one filed per record as opposed to several...
one for... Address_1, Address_2, City, State, Zip

Thanks for your suggestions.

Mel

 

[dbahooker]

it's bad in theory; but if it makes your life easier; then just do it

 

[KARL DEWEY]

You can print the 3 or 4 lines even with separate fields by concatenating
into a string with return and line feeds.
If you ever, in some distant future, need to sort it will be hard to split
the memo field.

 

[Vladimír Cvajniga]

No problem - use memo if you wish. But I wouldn't do it that way - I'd
rather store data in separate fields.

Vlado

 

[Tony Toews [MVP]]

Oh how many times have we heard that one. ...

I guarantee you that two weeks after you spend many many hours putting
all this stuff together someone is going to say "I need .... "

It is going to happen. Maybe they will discover that they can save a
little on postage by sorting by zip code or they need to know how many are
in what state etc. Trust me on this, it is far easier to do it right from
the beginning.

Absolutely agreed.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm