Memo Field

[John]

Hi
I have a form which has a memo field inserted. The field is linked to a
table where the memo field is set. The problem is that I cannot type more
than 255 characters into the memo field. If I type 300 then the last 45 are
missing. If I type the 300 characters directly into the table memo field
then all the characters are shown in the form memo field.

any ideas?

Kind Regards

John

 

[Rick Brandt]

Hi
I have a form which has a memo field inserted. The field is linked
to a table where the memo field is set. The problem is that I cannot
type more than 255 characters into the memo field. If I type 300
then the last 45 are missing. If I type the 300 characters directly
into the table memo field then all the characters are shown in the
form memo field.
any ideas?

Most likely all characters are being stored, but there is something about your
TextBox or the query that the form is bound to that is truncating the *display*
of the characters beyond 255. You can confirm this by opening the table and
temporarily making the rows tall enough (and that column wide enough) to see the
entire contents of the memo field.

You will truncate a memo field if any Format or InputMask property is applied on
the TextBox on the form. The latter would also prevent you from actually typing
more than 255 characters so we should be able to rule that one out.

 

[John]

Thanks Rick,
I had a Greater than ">" in the format field to convert to uppercase on
exit. can this be achieved by code on exit of the the memo field without
truncating again. if so any ideas what i coul use.

Regards

John

 

[Rick Brandt]

Thanks Rick,
I had a Greater than ">" in the format field to convert to uppercase
on exit. can this be achieved by code on exit of the the memo field
without truncating again. if so any ideas what i coul use.

I use a two-pronged approach. In the KeyPress event of the TextBox I convert
all typed characters to upper case...

KeyAscii = Asc(UCase(Char(KeyAscii)))

Then (in case they paste anything) I use the AfterUpdate event of the TextBox...

Me!TextBoxName = UCase(Me!TextBOxName)

 

[John]

Thanks Rick

All is well now,

Kind Regards

John