Any problem with putting address in Memo Field ?

  • Thread starter Thread starter MyEmailList
  • Start date Start date
M

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
 
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.
 
No problem - use memo if you wish. But I wouldn't do it that way - I'd
rather store data in separate fields.

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

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.

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?
Click to expand...

You don't need a memo field to do that.
Reason? Requires only one filed per record as opposed to several...
one for... Address_1, Address_2, City, State, Zip
Click to expand...

Memo fields are not all that efficient for a number of reasons. Having
several fields is not a problem for Access, it likes them.
 
Joseph Meehan said:
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.
Click to expand...

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
 
Back
Top