I have a recordset from which I want to load values into a listbox. The list will have three segments, Name, Unit, and Price all on one line. This was easy to do with Access 2002 because the additem property of the list box exists, however, I am now working in access 2000.
I'm adding the items by concatenating them in the rowsource property. The problem here is that one of the fields is currency and I want it show up like currency and when the row source sees the commas in the currency it skips to the next line thus making the display look funny.
How is this problem usually dealt with?
Thanks,
Dave
I'm adding the items by concatenating them in the rowsource property. The problem here is that one of the fields is currency and I want it show up like currency and when the row source sees the commas in the currency it skips to the next line thus making the display look funny.
How is this problem usually dealt with?
Thanks,
Dave
