Memo Field Length Bug (?) Question

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi All,

I'm experiencing an odd issue with a field where the data type is memo. I
know that it should hold 65K+ characters, but when I force everything to
uppercase in the field (using > in the format) Access truncates everything
past 255, just like it's a text field. I know that the additional
characters are there because if I exit the app, go back in, and remove the
formatting >, all the text is there.

Anyone know if this is a bug/feature/I'm crazy...

Thanks & Ciao,

Tony
 
Tony said:
Hi All,

I'm experiencing an odd issue with a field where the data type is memo. I
know that it should hold 65K+ characters, but when I force everything to
uppercase in the field (using > in the format) Access truncates everything
past 255, just like it's a text field. I know that the additional
characters are there because if I exit the app, go back in, and remove the
formatting >, all the text is there.
Click to expand...

Anytime you apply formatting to a memo field you will truncate it at 255
characters. Also if you use it in a Group By or if in a query with
DISTINCT.

If it is just for display you can use UCase() to display all caps instead.
 
Tony said:
Hi All,

I'm experiencing an odd issue with a field where the data type is
memo. I know that it should hold 65K+ characters, but when I force
everything to uppercase in the field (using > in the format) Access
truncates everything past 255, just like it's a text field. I know
that the additional characters are there because if I exit the app,
go back in, and remove the formatting >, all the text is there.

Anyone know if this is a bug/feature/I'm crazy...
Click to expand...

You're crazy. :-) No, just kidding. This is a real phenomenon,
whether you decide it's a bug or a feature. When you apply formatting
to a memo field, it behaves as though it were a text field. You'll have
to remove the ">" format. Do you want the field to contain only
upper-case characters? If so, then on the form where you update it, you
can have an AfterUpdate procedure for the text box that does this:

Private Sub MyMemoField_AfterUpdate()
Me.MyMemoField = UCase(Me.MyMemoField)
End Sub
 
Rick & Dirk,

Thanks for the heads up. I'll try UCase and see how things work.

Thanks & Ciao,

Tony
 
Rick Brandt said:
Anytime you apply formatting to a memo field you will truncate it at 255
characters.
Click to expand...

I'll be darned. I never knew that. Wow, learning something new every
month. <smile>

Mind you I never use formatting.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top