Currency in List Box - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Currency in List Box

Jim Baldner

5 years ago

I have a two-column unbound Listbox populated by code. I have formatted the second column as Currency. Appears fine in the statusbox. However, when using the additem to populate the list box, only the digits left of the thousands delimiter (,) appear.
See Pics..

thx in advance..

	Jim Baldner OP @Reply 5 years ago

	Jim Baldner OP @Reply 5 years ago

	Richard Rost @Reply 5 years ago
That comma may be messing things up. Remember, unbound list boxes want every column to be text, so try putting quotes around that field: `.AddItem TicketNumber & ";""" & Format(Total,"Currency") & """"` See if that works.

	Jim Baldner OP @Reply 5 years ago
Perfect, thx Richard

	Jim Baldner OP @Reply 5 years ago

	Richard Rost @Reply 5 years ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View