Street Address Imput Mask

[M Landon]

Scott & Arvin,

I tired both of your suggestions but I get an error stating "The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you enter the macrogroupname.macroname syntax in an argument, you must specify the name the macro's macro group was last saved under." Do I need to create a macro and if so I don't know how too.

Thanks again for any info.

 

[fredg]

Scott & Arvin,

I tired both of your suggestions but I get an error stating "The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you enter the macrogroupname.macroname syntax in an argument, you must specify the name the macro's macro group was last saved under." Do I need to create a macro and if so I don't know how too.

Thanks again for any info.

You have entered their code ON the AfterUpdate LINE not in the
AfterUpdate event procedure where it belongs.

Here's how to do it.
On the Control's AfterUpdate event line, write:
[Event Procedure]
Then click on the button with the 3 dots that will appear on that
line.
When the code window opens there will be 2 already existing lines.
Write the code
MyTextBox = StrConv([MyTexBox ],3)
between those 2 lines.
Change MyTextBox to whatever the actual name is of that control.
Exit the code window.
Run the form.