Format list box contents

  • Thread starter Thread starter Zebble
  • Start date Start date
Z

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?
 
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
 
Have you tried using a SQL select statement as source like this --
=SELECT Format([MyField], "$0.00"), [NextField] FROM [MyTable] ORDER BY
[NextField];
 
Karl:

I'll give that a try, Thanks.

KARL DEWEY said:
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


Zebble said:
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?
Click to expand...
Click to expand...
 
Back
Top