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?

Data that was entered or updated after you added the code to the AfterUpdate event should be fine. If you need a one-time fix for existing data, use an update query.

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).]

In the Update to cell put:

UCase(tblName.FieldName)


or You can use

StrConv(tblName.FieldName,1)

In SQL, I think that you need to use the vb constant values rather than their names. So, I replaced the constant name vbUpperCase with the literal value 1.

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