Memo field character limits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Forget the union stuff, not relevant here, have you tried to enter more than
255 characters in the underlying table?
 
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
 
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?
 
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.
 
aha, so it is actually storing all the chars but only showing the first 255,
makes sense.
 
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]
 

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

Query in vb.net not returning all characters in access memo field 1
Memo type field size 7
ADO help : 255 Character limit on memo field....!??!?!? 4
Memo field is automatically changing to text field in count query 3
Memo field character spaces-Help! 3
Strange Asian looking characters in output 3
Truncate Memo field in Union Query 6
Memo Field in Table Truncated in query results and in report 1

Back
Top