T
Ted
If your data format is consistent, such as with phone
numbers, you can use an input mask to insert/specify
things like parenthesis, spaces, hyphens, uppercase,
etc. To do this, view the properties of a control, click
on the data tab, and look for "Input Mask".
Access has some built in masks (such as for phone no)
which you can get to by clicking just to the right of the
empty "Input Mask" field. Or, you can click inside the
empty field and press F1 for help on creating custom
masks.
Otherwise, your only choice may be to build the values
that you want using various text functions as mentioned
in the other reply. Hope this helps.
-Ted
numbers, you can use an input mask to insert/specify
things like parenthesis, spaces, hyphens, uppercase,
etc. To do this, view the properties of a control, click
on the data tab, and look for "Input Mask".
Access has some built in masks (such as for phone no)
which you can get to by clicking just to the right of the
empty "Input Mask" field. Or, you can click inside the
empty field and press F1 for help on creating custom
masks.
Otherwise, your only choice may be to build the values
that you want using various text functions as mentioned
in the other reply. Hope this helps.
-Ted