Memo field character spaces-Help!

[JudyT]

Ok, I have a table with a memo field that I have set to format > "all Capital
letters" , so that our guys do not have to worry about enter title caps and
the like...Well when I format it for that, as you know, it turns the field
character capacity to 255. Is there a way around this issue. I need the
memo field to be unlimted or 65K as usually set for memo field. Please help!

Thank you in advance!
JudyT

 

[Duane Hookom]

I don't think using the Format property has any effect on what is actually
stored in the field. Consider using code in the On Keypress event of your
text box on your form:
Private Sub txtMemo_KeyPress(KeyAscii As Integer)
Select Case KeyAscii
Case 97 To 122
KeyAscii = KeyAscii - 32
Case Else
KeyAscii = KeyAscii
End Select
End Sub

 

[TC]

Why on earth would you want loads & loads & loads of text - which is
what a memo field is for - all of it in upper case?

Perhaps there's a better way to achive the end result you're after.

TC (MVP Access)
http://tc2.atspace.com