Memo field character limits

M

Mike

I have a form that uses information from a table called "customer". In that
form and table I have a field titled "resolution" that is a memo field.

Also on that form, I have a "tab" with information from a table titled
"followup". It to has a memo field titled "action".

My problem is that the field titled "resolution" will only show 255
characters. The "action" field works fine. How can I get the "resolution"
field to allow/show more characters.

I ready earlier about "union all" querry. I'm not sure if I have to do that
since the information is not coming from a querry. If I do have to do that,
how do I make a Union All querry. I have no idea.

Thanks
 
A

Alex White MCDBA MCSE

Forget the union stuff, not relevant here, have you tried to enter more than
255 characters in the underlying table?
 
M

Mike

Yes I have tried it. It works fine. The next thing I was wondering?? I have
the memo field format as >, could that cause the problem?

Thanks
 
A

Alex White MCDBA MCSE

tested the > allows way passed 255, you say in our original post "field
titled resolution" what about the textbox on the screen what is its control
source?

can you give me the field spec in the customer table for resolution?
 
R

Rick Brandt

Alex said:
tested the > allows way passed 255, you say in our original post
"field titled resolution" what about the textbox on the screen what
is its control source?

can you give me the field spec in the customer table for resolution?
Click to expand...

Sorry, but it is the > in the format. It allows you to enter as much as you
want but as soon as you leave the control you will only see 255 characters.
 
A

Alex White MCDBA MCSE

aha, so it is actually storing all the chars but only showing the first 255,
makes sense.
 
J

John Vinson

Yes I have tried it. It works fine. The next thing I was wondering?? I have
the memo field format as >, could that cause the problem?
Click to expand...

YES.

Any formatting on a textbox will limit it to 255 bytes.

Remove the format and you should be ok.

John W. Vinson[MVP]
 
Top