Ucase help (1 Viewer)

[GRM-kenyette]

hi all
I have a form that has textboxes, a combox and a subform, when i complete a record, I will like everything to capitalized in the table but I can't seem to figure out how to do this on the subform fields.
I tried the ucase function for the after update but the subform doen't have an after update

 

[RichO]

Is your subform a continuous form?

The subform actually does have an After Update event in its form properties. Click twice in the upper left corner to get to the actual form properties.

 

[GRM-kenyette]

I click twice in the left corner of my subform in form view nothing happens , and then I tried in design mode and the properties pop open but I only get Enter or Exit events

 

[RichO]

In design mode when you see On Enter & On Exit, click once more in the top left corner and the actual form properties will appear.

Is this is continuous subform? The reason I ask is that if you use a loop to UCASE all of the text boxes, it will only do the current record in a continuous form.