Memo Fields and Formatting on Forms

[JustineB]

Has anyone else had this problem??

I have a memo field in a table, which is filled in by using a form.

The users want the text to be formatted in CAPS. For this reason I entered a '>' in the formatting in the properties for the memo field on the form.

The problem that I have now is that the text is limited to 255 characters.

As soon as I remove the formatting, the user is allowed to freely enter as much text as possible again.

Are there any work-arounds with this, or do we just have to live with it?

Thanks in advance to anyone that answers.

Justineb

 

[krispi]

A workaround is to convert the text to uppercase in the after update event of the memo field

Me!FieldName = Ucase(Me!FieldName)

HTH

Chris

 

[mcfaddea]

I have just attempted to recreate your problem and can't. All I can suggest is that you remove the field from the form, ensure the format is correct in the table, i.e. memo selected with format > and then reinsert field in form.

Worked for me, let me know what happens??

Alan

 

[JustineB]

Thanks both of you for your helpful suggestions.

Unfortunately, neither of them worked. I am beginning to think that I am going mad...

The field is straight off a table, no query involved or anything. The data is all stored there in the field, but once it is in capitals, I can only view the first 255.

I think that the only way of getting this data into Capitals is by forcing the user to type them in with Caps lock on.

If you have any other ideas, I would certainly appreciate it!

Thanks again
Justine

 

[mcfaddea]

sorry for late reply but been away for while!!

You could use the VB sendKeys command on somethng like gotfocus for the field of the form. In this way when the field gets focus from mouse click or tab the vb command will run forcing caps lock on.

You will have to force caps off by sending same command from lostfocus.