I have a combo box on a form with the following code in the After Update event:
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Name] ='" & Me![Combo77] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
I want the data displayed in the combobox to be Upper Case.
The ">" does not work in the properties format; Nor does the Ucase work in the underlying query.
Is there a line of code that can be added to the after update event procedure that will accomplish this?
Or should there be an event procedure in "lost focus"
Thank you in advance for any help that you can give.
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Name] ='" & Me![Combo77] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
I want the data displayed in the combobox to be Upper Case.
The ">" does not work in the properties format; Nor does the Ucase work in the underlying query.
Is there a line of code that can be added to the after update event procedure that will accomplish this?
Or should there be an event procedure in "lost focus"
Thank you in advance for any help that you can give.