If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
memo type
How do I define a memo or data type larger than string in Access code?
Thanks. |
#2
|
|||
|
|||
In your table design, select memo under Type.
-- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions " -00Eric Clapton" wrote in message ... How do I define a memo or data type larger than string in Access code? Thanks. |
#3
|
|||
|
|||
In fact, what mean is to define the memo in Module code. Something like:
Dim variable as (memo) How can I define as above? Thanks. "Al Camp" wrote in message ... In your table design, select memo under Type. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions " -00Eric Clapton" wrote in message ... How do I define a memo or data type larger than string in Access code? Thanks. |
#4
|
|||
|
|||
" -00Eric Clapton" wrote in message
In fact, what mean is to define the memo in Module code. Something like: Dim variable as (memo) How can I define as above? Dim variable As String The String data type can hold up to 2^31 characters. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#5
|
|||
|
|||
Eric,
Keying off of Dirk's response. If a string variable (at 255 chars) is not large enough, you'll have to split your long "memo" string into several string variables. They could be reunited later. ex. MyString1 (255 chars) and MyString2 (84 chars) Something = MyString1 & MyString2 hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions " -00Eric Clapton" wrote in message ... In fact, what mean is to define the memo in Module code. Something like: Dim variable as (memo) How can I define as above? Thanks. "Al Camp" wrote in message ... In your table design, select memo under Type. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions " -00Eric Clapton" wrote in message ... How do I define a memo or data type larger than string in Access code? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Concatenation of the Memo Data Type Field | m dowling | General Discussion | 3 | March 24th, 2005 10:12 PM |
memo field truncation: new problem | whincup | Running & Setting Up Queries | 2 | November 16th, 2004 08:40 AM |
row which has TOTALS of coulmns? | confused | Running & Setting Up Queries | 5 | September 13th, 2004 01:02 AM |
Memo Field data truncated in query | Joel | Running & Setting Up Queries | 3 | August 4th, 2004 03:40 PM |
memo type field is truncating on form | cindy muth | Using Forms | 2 | June 17th, 2004 04:33 PM |