I tested what you had posted as far as what all you have done. It is
crazy
that even if you have format in the query set, it ignores it. I don't
know
if there is some setting somewhere that will change that, but based on my
testing, this should work
SELECT DISTINCT Format([IDLength], "#,##0.0000") As IDLen
FROM tblPKCGPhysicalAttributes
ORDER BY Format([IDLength], "#,##0.0000");
:
SELECT tblPKCGPhysicalAttributes.IDLength FROM
tblPKCGPhysicalAttributes
GROUP BY tblPKCGPhysicalAttributes.IDLength ORDER BY
tblPKCGPhysicalAttributes.IDLength;
--
www.Marzetti.com
:
You keep saying you have no row source.
If you don't have a row source, nothing will appear in a combo.
You say you are using a query.
Please post the query and the code where you are intitiating the
query.
Now the reasonn 4 decimals are showing is because the format property
applies to what is presented in the text box portion of the combo,
not what
is presented in the list box portion.
If I can see the query and how you are calling it, maybe there is a
solution.
:
More than enough.
Is it because the field size in the table is Double? That's the
only
difference I see between the Table, Query, and Combo Box
properties.
--
www.Marzetti.com
:
I don't know, but sorry if this is a stupid and obvious
question -- are you
sure the combo column width is wide enough to display all 4
digit?
:
That's correct. I was trying to distinguish that there is
nothing in the Row
Source property of the combo box.
So basically there's nothing I can do about this?
--
www.Marzetti.com
:
The query then is the row source. What a combo is bound to
is totally
different from the row source. The row source is where the
combo gets the
items to display. The Control Source is what binds the
control to a field in
the form's record source.
:
There is no row source. It's unbound and queries a query of
a table with
Fixed fields at 4 decimals.
--
www.Marzetti.com
:
What is the row source of the combo box? If it is a
query or table, verify
that it's format display properties are fixed at 4
decimals.
JohnLute wrote:
I just ran this again. What's strange is that when I
activate the combo box
the values appear in 2 decimals that are rounded up the
the highest
hundredth. When I make a selection the number converts
to 4 decimals!
Very peculiar. It's somewhat disorienting as what
appears in the box and
then what's actually selected are two different things.
Try changing the format of the combo box controls.
Set the format to fixed
at 4 decimal places.
[quoted text clipped - 7 lines]
Why is that?