|4GuysFromRolla.com : ASP FAQS : Databases, General|
|Question:||My memo fields show up as blank! OR When I test my memo field for a value and then try to show it only if it is not blank [or only if it contains some string or or or], then when I display it I get nothing!|
|Answer:||To use Memo fields in Access (and longer VARCHAR fields in various other DBs), you must "follow the rules." Which are:|
(1) The memo field should be the last field in your list of fields.
(2) You can only retrieve the value of a memo field from the recordset ONE TIME.
Or you can follow the other set of rules, below...
Often this means that you must specifically call out the fields you are reading, via
instead of simply
Stacy reports that if you do this, you no longer have to worry about the order of the fields or the other restrictions noted above.
FAQ posted by Bill Wilkinson at 11/7/2000 9:12:07 PM to the Databases, General category. This FAQ has been viewed 58,032 times.
Copyright 2019 QuinStreet Inc. All Rights Reserved.
Advertise | Newsletters | E-mail Offers