Input Mask within Message Box

[Jerry8989]

I was wondering if there was a way for a message box to display a text box value with the input mask?

I have a text box that displays 000-0000-0XX0 but when I message box this value it shows up as 00000000XX0.

I thought this was something simple I haven't been able to find anything on it.


Thank You for any help

 

[namliam]

A messagebox is nothing but a text message, beeing text it shouldnt have a problem displaying ...

msgbox "000-0000-0XX0 " seems to work just fine for me

The issue you may have is that your textbox actualy only stores 00000000XX0 but displays as 000-0000-0XX0 due to a display format, in which case your F-ed...
You will have to reformat the display for the messagebox

 

[Jerry8989]

nam,
I'm F'ed LOL
That is how it's working for me. It's just a mask the data doesn't have the dashes.

Thanks for your help

 

[boblarson]

You should be able to use:

Format(Me.YourTextBox,"000-0000-0LL0")

 

[Jerry8989]

bob,
Thank you so much for your help.
I'm close now but it is having problems with the character part of it.
If I use Format("2222C", "###-##") I get back 2222C
If I use Format("12345", "###-##") I get back 123-45
Is there a wild card for character?

Thanks

 

[boblarson]

bob,
Thank you so much for your help.
I'm close now but it is having problems with the character part of it.
If I use Format("2222C", "###-##") I get back 2222C
If I use Format("12345", "###-##") I get back 123-45
Is there a wild card for character?

Thanks

Look at my post again, it shows an L for a character.

 

[Jerry8989]

I tried this Format("1234B", "###-#L") and it didn't work still shows 1234B

Thanks for your quick reply