Memo Field

A

accessdesigner

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

M Skabialka

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

Jerry Whittle

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?
 
A

accessdesigner

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, ....
 
P

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.
 

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

Top