Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Database memo fields truncated to 255 char - help!
And the clouds parted and the golden light of understanding illuminated the code! Thanks Golom for your prod, PHV for your answer, fneily for showing the working-out! Very much appreciated indeed. I'm working this VBA business out myself as I go and it's this kind of support that makes it...- Whymars
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Database memo fields truncated to 255 char - help!
Hi, thanks for your reply - here's the SQL. Sorry it's a bit of a stinker but I couldn't think of a way to simplify it. The table the memos come from is called gr_gr-session_data. Most of the other sources referred to in the SQL are queries themselves. text1, text2 and text3 are the names of...- Whymars
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Database memo fields truncated to 255 char - help!
Hi folks, first time post here, so please be gentle :) I have a database that contains a table with a number of memo-type fields (text1, text2, text3). These can't be text-type because they can potentially contain upwards of a few thousand characters (255 char limit on text). Now, I've got a...- Whymars
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
