memo field - max number of characters. 4

[brent01]

Help,

I have a single form, with an underlying single table. One field in the table, is set as a Memo data type, and there is corresponding field, in the form, which uses the Memo table field as it's data source. I have set the Format for the Memo table field, and the form field to '>', so that any free text type in that field is shifted to uppercase, both in the form view, and table view.

Unfortunatley, any text typed into the memo field, whether via the form or directly into the table, only displays appox., the first 240 characters.

If I remove the '>' format from the Table field, it then displays, all the characters I type in Table view, and if I remove the '>' format from the form field, it also displays all characters typed. However, everything is now displayed, in the case it was originally entered.

Also I am experiencing the exact same problem, with the report that uses this Memo field. It will only display the first 240 or so chars, Unless I remove the Uppercase format property.

Is there anyway to fix this problem, so that any text entered into this field, or displayed, by the form or report, can be forced into uppercae, and diplay all the text, not just the first 240-250 chars??

Any help, greatly appreciated.

 

[CosmoKramer]

Make sure that the "Can Grow" property of the text boxes of both the report and form are set to yes. The field on the report will expand to accomodate the size, and the field on the form will utilize scroll bars if that property is set to "Vertical".

 

[JerryDennison]

When you use any type of formatting on the field you've effectively changed the datatype from Memo to Text. Thus the 255 character limit. I'm not sure you'll be able to overcome this problem. Can you live with upper and lower case?

 

[CosmoKramer]

Don't do the formatting at the table level, do it at the form level, and everything should be OK.

 

[tlbroadbent]

The > causes the trucation. Check the following articles.

ACC 2000: Formatted Memo Field Appears to Truncate Data After 255 Characters

http://support.microsoft.com/support/kb/articles/Q259/8/93.asp

ACC 97: Formatted Memo Truncates Data at 255 Characters

http://support.microsoft.com/support/kb/articles/Q103/9/98.asp

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[JoeMiller]

This would be a two step process to get rid of the > so you get all your characters back, switch all the old data to uppercase and set it up so that going forward all data entered is in uppercase without using >.

To switch the characters all to uppercase you can use UCase([MyField]) in an update query to set all characters to UCase. I tested this and it will not strip any characters from your field.

Now that all the old data is fixed you have to ensure that no new data is entered in lower case. And you can do that by placing one line of code in the keypress event of the control on the form where this field is edited. Here's the line of code:

KeyAscii = Asc(UCase(Chr(KeyAscii)))

Then you shouldn't have to worry about mixed case anymore.

HTH Joe Miller
joe.miller@flotech.net