Format access field on form object

  • Thread starter Thread starter MacRae
  • Start date Start date
M

MacRae

This is the input mask/display format i use for a text field:
00-000;;0

What I want to do is have that same format within a list box.
If I put in Format([Job_Number],"00-000;;0") it just flat out does not
display at all.

Could someone advise? Thanks
 
Hi MacRae,

If you use Format([Job_Number],"00-000") it should work - formatting and
input masking are two slightly different things.

If you are using a list box, it might pay to have your format statement in
the select query for the datasource.

Hope this helps.

Damian.
 
Hi MacRae,

If you use Format([Job_Number],"00-000") it should work - formatting and
input masking are two slightly different things.

If you are using a list box, it might pay to have your format statement in
the select query for the datasource.
Click to expand...
yea i had that in the select query

cheers broo
Hope this helps.

Damian.

MacRae said:
This is the input mask/display format i use for a text field:
00-000;;0
Click to expand...
What I want to do is have that same format within a list box.
If I put in Format([Job_Number],"00-000;;0") it just flat out does not
display at all.
Click to expand...
Could someone advise? Thanks
Click to expand...
Click to expand...
 
Back
Top