[AccessD] Format a numeric column in a list box?

Listbox rows are essentially strings.  You need to use the Format$()
function to convert the value to a string in the query if you want a
single decimal place in the list.

Charlotte Foust 

-----Original Message-----
From: Paul Baumann [mailto:Paul.Baumann at rtctech.com] 
Sent: Wednesday, May 05, 2004 11:36 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Format a numeric column in a list box?


I have a list box in which one of the fields is a number with one
decimal place. The table that the value is coming from is set to one
decimal place. I have set the format for the column in the query that
selects the data for the list box to one decimal place. But, when I open
the form the column in the list box displays 2 decimal places.

I am running out of hair to pull out.

Paul Baumann
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com