Decimal places in combo boxes

[Jessica]

Greetings!

I have a table that has a number fields, latitude, that is
single, fixed, and 5 decimals. I have a form with a combo
box that's control source is query back to this table
grouping by like latitudes. I have set the properties of
this combo box to fixed and 5, but all I see are numbers
with 2 decimal places! I can not get my 5 decimals to
show up at all. It does give me the 'grouping' for the
decimals but they all show up as the 2 digit decimals.
For example, 72.58465 and 72.58124 both show up as 72.58.
So instead of:

72.58124
72.58465

in the combo box I get:

72.58
72.58

Any suggestions on how to get past all of this?

Jessica

 

[John Smith]

You need to format your number in the query. For example, if the column is
called latitude then :-

SELECT Format$(latitude, "#,##0.00000")
FROM YourTable
GROUP BY Format$(latitude, "#,##0.00000") ;

 

[fredg]

Greetings!

I have a table that has a number fields, latitude, that is
single, fixed, and 5 decimals. I have a form with a combo
box that's control source is query back to this table
grouping by like latitudes. I have set the properties of
this combo box to fixed and 5, but all I see are numbers
with 2 decimal places! I can not get my 5 decimals to
show up at all. It does give me the 'grouping' for the
decimals but they all show up as the 2 digit decimals.
For example, 72.58465 and 72.58124 both show up as 72.58.
So instead of:

72.58124
72.58465

in the combo box I get:

72.58
72.58

Any suggestions on how to get past all of this?

Jessica

In the RowSource Query/SQL that populates the combo box, use:
Format([FieldName],"#.00000")
instead of [FieldName].