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

PS.

Instead of the hand-rolled strPad function you could use the built in Rset
function.

Lambert

> -----Original Message-----
> From:	Jim Hewson [SMTP:JHewson at karta.com]
> Sent:	Thursday, May 13, 2004 8:38 AM
> To:	Access Developers discussion and problem solving
> Subject:	RE: [AccessD] Format a numeric column in a list box?
> 
> 
> To piggyback on this thread, I have a question.
> How can you format a numeric column to align on the right?
> I want numbers to look like numbers - not text.
> This would apply to the list box and combo box.
> Thanks,
> Jim
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
> Foust
> Sent: Wednesday, May 05, 2004 2:57 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com