0
-00Eric Clapton
How do I define a memo or data type larger than string in Access code?
Thanks.
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Al Camp
In your table design, select memo under Type.
0
-00Eric Clapton
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.
Dim variable as (memo)
How can I define as above?
Thanks.
D
Dirk Goldgar
-00Eric Clapton said: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.
A
Al Camp
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
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