Format field in query

[Leventcos21]

Hi,

How can I format a field to display a certain way in a combo box. For example, I am trying to display the values in the combo box in a 3 decimal format. 1.010., 1.000, 2.500, etc.

I don't know if this is the correct way in the field type in the type I labeled it as currency and in the text boxes I format it to #.### & 3 decimal places.

How is this possible in a combo box? I tried the samething as I did in a text box but it doesn't work.

 

[Leventcos21]

sorry for the post I think I got what I was looking for.

I did this test:Format([number],"0.000")

 

[Remou]

The best bet is to format the row source.

Select Format([FieldName], "Currency") From tblTable