memo type

How do I define a memo or data type larger than string in Access code?
Thanks.

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.

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.

" -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)

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.