Memo field character spaces-Help!

[Guest]

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

 

[Joseph Meehan]

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

I just played with mine (Access 2000) and it did not change the field
type property (limiting size) nor did it change the data as it is still
stored as mixed case and only changes the way it is displayed in the Table
and other non-formatted queries, reports and forms.