A
accessdesigner
my memo field will not allow characters past 257 characters when typing in
data from a form, why won't it?
data from a form, why won't it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
M Skabialka
Are you sure you defined the field as memo, and not text with a limit of 255
characters?
Mich
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?
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, ....
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.
KeyAscii = Asc(UCase(Chr(KeyAscii)))
which converts all text to upper case as you enter it.
Peter Hibbs.