length of Memo in Microsoft Access 2002

[Guest]

How should I design the length of "MEMO" in a Data Type. So that according my
setup the user can feed minimum to maximum character in the field.

 

[Brendan Reynolds]

Stephen Lebans has a solution for this at the following URL ...

http://www.lebans.com/limitcharsmemo.htm

 

[Guest]

Dear Brendan,

Thanks for your suggestion, is there any other style coz i don't want the
user to change the length, it should be hidden in FORM, say fix length of the
MEMO is 35, no one can change except me.

 

[Brendan Reynolds]

Stephen's form is just an example demonstrating how to use the code, Jay.
You can modify the code to suit your purposes. For example, try changing
this line ...

lngNewMax = Len(Me!testmemo.Text & "")

.... to ...

lngNewMax = 350

.... or whatever you want the max number of characters to be.