length of Memo in Microsoft Access 2002

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making backup of memo of fields 1
Memo Field in Table Truncated in query results and in report 1
Memo Length Restriction 3
New line in memo box 5
Memo Field Text Hidden 2
Limit Memo field to 1500 Characters? 3
text length in a text box versus memo field 2
Write to a Memo Field 1

Top