number format in listbox

[clive2002]

Think i must be missing something but im having real probelms formatting numbers show in a listbox. I want , seperatots but not decimals, dont seem to be able to one without the other.

someone put me outta my misery please.

 

[ansentry]

Post an example of what you want.

do you want 123-45 or 123,45 or what?

 

[clive2002]

yeah,

i suppose that would be helpful.

I can get 222,235,244.00 or 2222352444

but what i want is 222,235,244

thanks

 

[Dreamweaver]

Set the decimal places to 0 instead of auto for the display control and table if ya want.

mick

 

[clive2002]

yeah even i thought of that, lol.

also tried setting table field to long integer which cant even store a decimal still wouldn't change, on verge of routing through a query and running each column through a Format() function, just to see if that will do the trick, but their must be something cleaner im missing?

 

[ansentry]

Have a look at my attached sample:

 

[NimbusSoftware]

Use the Format$ function to get the number to look the way you want.

Format$(X,"#,##")

 

[clive2002]

Thanks Guys,

Guess i will have to pass through a function.

I attach your file back with the problem highlighted in an additional form ansentry, just to clarify the issue. (don't have winzip so ive just renamed .zip, but if you rename back to .mdb it should work.

 

[ansentry]

What you have not done is formatted the "MyNumbers" in the query that is the source for the list box. I just changed you sample and it worked for me.