Memo Field

[Guest]

my memo field will not allow characters past 257 characters when typing in
data from a form, why won't it?

 

[M Skabialka]

Are you sure you defined the field as memo, and not text with a limit of 255
characters?
Mich

 

[Guest]

1. Are you really, really sure that it's a memo field and not a text field? I
had to ask.

2. Is there some strange validation rule at either table or form level?

3. Is the form based on a query or directly on the table? If on a query, try
basing a form directly on the table.

4. Are you using any functions like UCase on the memo field?

 

[Guest]

yep, the ">" in the form field, took it out and it's ok, but id rather have
it in... the form is based off the query, ....

 

[Peter Hibbs]

Add this code to the KeyPress event.

KeyAscii = Asc(UCase(Chr(KeyAscii)))

which converts all text to upper case as you enter it.

Peter Hibbs.