Ive done something to cause an 'invalid outside procedure' warning (1 Viewer)

[Lonemascot]

I've done something naughty with my DB.

My 'contact details' form usually shows the [contact name] in the header of the form. However, if I enable active content then this doesn't work. Then when I go into design view and back out again it says there is an 'Invalid Outside Procedure'.

it was all working and then i was faffing around with the macro builder (i was trying to make a macro that made text into proper case) and now its not behaving.

the only other thing that looks a bit strange is the macro assigned to the search box under the header. theres a little yellow warning image.

could someone be kind enough to look at this blasted thing and tell me wha needs doing please.

 

[pr2-eugin]

You have placed the following in a VBA form module..

Action: SetValue
Item: Screen.ActiveControl
Expression: StrConv(Screen.ActiveControl,3)

 

[Lonemascot]

Thank you so much. I remember pasting that in there now! duh.

Perhaps you could help me with what i was trying to do in the first place which was have all my text boxes auto convert to Proper Case.