length of Memo in Microsoft Access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.
 
Back
Top