Fixed Format and Decimals in Combo Box

[Guest]

I'm using a form to filter values in a query. I have unbound combo boxes that
query fields in a table that are Fixed and set to 4 decimals. The combo boxes
are also setup accordingly.

When the form is opened the values in the combo boxes are rounded up and at
2 decimals.

Why is that?

 

[kingston via AccessMonster.com]

Try changing the format of the combo box controls. Set the format to fixed
at 4 decimal places.

 

[Guest]

Thanks!

The combo boxes actually are formatted Fixed with 4 decimals. That's why
this is so mysterious to me.

 

[Guest]

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.

 

[kingston via AccessMonster.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.

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]

 

[Guest]

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.

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?

 

[Guest]

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.

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?

 

[Guest]

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?

 

[Guest]

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?

 

[Guest]

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?

 

[Guest]

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?

 

[Guest]

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?

 

[Guest]

My apologies. I was in the middle of trying a few different things and got
lost as to what I'm actually doing.

I just posted the source.

--
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?

 

[Guest]

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?

 

[Guest]

THANKS!!!

That works. I'm glad it was behaving the same for you, too. It looks like I
stumbled upon an Access bug...?

--
www.Marzetti.com

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?

 

[Guest]

ARRRRGGGGHHHHH!

This works BUT I just noticed that the sorting is whacky. Instead of this:

1
2
3
10
20
30

It returns:

1
10
2
20
3
30

I'm actually trying to resolve this problem for a form in a different
thread! Now I have it also in a query!

For a report I use this:
=Right(" "&[FieldName], 4)

This works fine in the report but it's killing my form and I've yet to
resolve it. Would this work for the query? I'm having trouble writing it in.
If not, what could I do?

Thanks for all of your time and patience!

--
www.Marzetti.com

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?

 

[Douglas J. Steele]

Does it work if you remove the Format function from the ORDER BY clause?

SELECT DISTINCT Format([IDLength], "#,##0.0000") As IDLen
FROM tblPKCGPhysicalAttributes
ORDER BY IDLength


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

ARRRRGGGGHHHHH!

This works BUT I just noticed that the sorting is whacky. Instead of this:

1
2
3
10
20
30

It returns:

1
10
2
20
3
30

I'm actually trying to resolve this problem for a form in a different
thread! Now I have it also in a query!

For a report I use this:
=Right(" "&[FieldName], 4)

This works fine in the report but it's killing my form and I've yet to
resolve it. Would this work for the query? I'm having trouble writing it
in.
If not, what could I do?

Thanks for all of your time and patience!

--
www.Marzetti.com

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?

 

[Guest]

I thought of that and gave it a shot. It returns a conflict: ORDER BY clause
conflicts with DISTINCT.

---
www.Marzetti.com

Does it work if you remove the Format function from the ORDER BY clause?

SELECT DISTINCT Format([IDLength], "#,##0.0000") As IDLen
FROM tblPKCGPhysicalAttributes
ORDER BY IDLength


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

ARRRRGGGGHHHHH!

This works BUT I just noticed that the sorting is whacky. Instead of this:

1
2
3
10
20
30

It returns:

1
10
2
20
3
30

I'm actually trying to resolve this problem for a form in a different
thread! Now I have it also in a query!

For a report I use this:
=Right(" "&[FieldName], 4)

This works fine in the report but it's killing my form and I've yet to
resolve it. Would this work for the query? I'm having trouble writing it
in.
If not, what could I do?

Thanks for all of your time and patience!

--
www.Marzetti.com

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?