Ensuring UpperCase

[Rich_Lovina]

In my MainForm I use an After_Update event to create capitals, i.e.
Me.[MyCombo] = StrConv(Me.[MyCombo], vbUpperCase)

....but in the related table the text remains LowerCase.

Is there anyway to ensure reltable or MainForm hold UpperCase, irrespective of user's entry?

 

[Rich_Lovina]

Dear Pat
Tks, that would be easier I guess, but I've jumped to so much VB, Ive forgotten the expression to build on the Update Query?
Any help, tks in advance.
Nb. Just searched the Help, tried
StrConv(UCase([Poscode]) in criteria, but no luck....must be close to this.

[This message has been edited by Rich_Lovina (edited 02-06-2002).]

 

[Rich_Lovina]

Tks Pat, remember now. 1st one similar to most programs.