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

Heenan, Lambert Lambert.Heenan at AIG.com
Thu May 13 09:42:32 CDT 2004


Here's the example form the help file...

Dim MyString
MyString = "0123456789"	' Initialize string.
Rset MyString = "Right->"	' MyString contains "   Right->".

Lambert

> -----Original Message-----
> From:	Jim Hewson [SMTP:JHewson at karta.com]
> Sent:	Thursday, May 13, 2004 9:52 AM
> To:	Access Developers discussion and problem solving
> Subject:	RE: [AccessD] Format a numeric column in a list box?
> 
> 
> I'm not familiar with the Rset function.
> How does it work?
> Jim
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Heenan,
> Lambert
> Sent: Thursday, May 13, 2004 8:31 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [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
> -- 
> _______________________________________________
> 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



More information about the AccessD mailing list