Contact Number's Format

[A9992736]

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?

[BrianMH]

Where are you formatting this? In a form? In a table?

[A9992736]

formatting in table as well as form.

[BrianMH]

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.