Format list box contents

[Zebble]

I'm building a list box from a query that shows an item and an amount. The
table where the amount comes from is formatted to show the amount as
currency. The query is also formatted to show the amount as currency. When
the amount displays in the list box, it displays as text (aligned left, no
currency symbol and no thousands separator). I've tried to change the SQL
query to display the amount correctly, but with no success.

Any suggestions?

 

[Bill Barbour]

I used to get bubbles on you tube breaking off into other bubbles of similar
content. Can someone please help me
get this back again.
Thanks
BB

 

[KARL DEWEY]

Have you tried using a SQL select statement as source like this --
=SELECT Format([MyField], "$0.00"), [NextField] FROM [MyTable] ORDER BY
[NextField];

 

[Zebble]

Karl:

I'll give that a try, Thanks.

Have you tried using a SQL select statement as source like this --
=SELECT Format([MyField], "$0.00"), [NextField] FROM [MyTable] ORDER BY
[NextField];

--
KARL DEWEY
Build a little - Test a little

I'm building a list box from a query that shows an item and an amount. The
table where the amount comes from is formatted to show the amount as
currency. The query is also formatted to show the amount as currency. When
the amount displays in the list box, it displays as text (aligned left, no
currency symbol and no thousands separator). I've tried to change the SQL
query to display the amount correctly, but with no success.

Any suggestions?