memo type

[-00Eric Clapton]

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

 

[Al Camp]

In your table design, select memo under Type.

 

[-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.

 

[Dirk Goldgar]

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.

 

[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