Format and Input Mask property question

M

mscertified

I have a column that can be either a 6 or 8 digit number and it must be
formatted as follows
99.99.99 or 99.99.99_99

How do I set up the imput mask and the format property to handle this,
currently I have:
00\.00\.00 for the input mask, and
@@\.@@\.@@ for the format
so I'm not catering for the possible suffix
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input Mask - quick question 6
date+time input mask 3
Time format hh:nn drops leading zero 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Format property 1
Input Mask for General Date/Time 1
Custom Date Format and Input Mask Trouble 5
Input Mask Help 1

Top