Hi viewers, please assist with this problem I encountered...
Example:
The current contact no. format shown is "63129999".
But I want a space in between to make it show like this : "6312 9999".
How can i format it?
Hi viewers, please assist with this problem I encountered...
Example:
The current contact no. format shown is "63129999".
But I want a space in between to make it show like this : "6312 9999".
How can i format it?
Where are you formatting this? In a form? In a table?
-----------------------------------------
The more you learn about something the more you know you have much to learn.
formatting in table as well as form.
well if you just want it to display that way then change the query you use to populate the form or get results to format(fieldname,"0000 0000")
IE
select format(fieldname,"0000 0000") as fieldname from table.
-----------------------------------------
The more you learn about something the more you know you have much to learn.