Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

List box Formating

Status
Not open for further replies.
tonytrini

tonytrini

Programmer
Nov 23, 2000
8
TT
I am using a listbox to display values from a currency field. Is there anyway I can format the listbox to display two decimals places instead of four?
 
Sort by date Sort by votes
Specify str(varname,8,2) as your rowsource in place of varname. Naturally, increase the 8 value if your data requires.
It's an ugly kludge, but it works.
Good luck.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

parkmingyu
  • Question
ComBo BOX Listindex ERR
Replies
1
Views
195
Chris Miller
Chris Miller
ameedoo3000
  • Locked
  • Question
show command box
Replies
13
Views
310
ameedoo3000
ameedoo3000
german12
  • Locked
  • Question
How to filter a list like this sample 3
Replies
2
Views
142
Chris Miller
Chris Miller
german12
  • Locked
  • Question
Sorting the object list of a form by its objects. 4
2
Replies
23
Views
366
german12
german12
SitesMasstec
  • Locked
  • Question
Itens in Combo Box 1
Replies
3
Views
147
SitesMasstec
SitesMasstec

Part and Inventory Search

Sponsor

Back
Top