By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

Text vs. Memo

100+
P: 153
I'm just throwing this idea out there...
I'm wrapping up work on an MS Access 2003 database....
would disasterous results occur if I were to convert all text fields into memo fields (and also set the can grow/ can shrink fields to yes)?
Jan 9 '07 #1
Share this Question
Share on Google+
3 Replies


100+
P: 153
Ehh I'm starting to hear memo's are very limited and buggy so I'll stick with texts I guess
Jan 9 '07 #2

NeoPa
Expert Mod 15k+
P: 31,186
I would do that Kosmos.
Like yourself I've not heard a lot of good things about Memo fields.
Steer clear where possible would be my advice.
Jan 9 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
I'm just throwing this idea out there...
I'm wrapping up work on an MS Access 2003 database....
would disasterous results occur if I were to convert all text fields into memo fields (and also set the can grow/ can shrink fields to yes)?
Memo fields can't be queried properly. They can also pick up a lot of characters that aren't recognised by Access. It's very hard to control how users use them.

The rule about memo fields is only use them when necessary and don't try to query them if you can avoid it.

Mary
Jan 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.