• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 568
  • Last Modified:

Format ListBox columns

How would I code in VBA from MS Access 2003 so that My values in Column(5) and Column(6) display as 0.00?

In my SQL I'm outputting this to the listbox
LB
This is my listbox as it displays right now
I want the 40.00 displayed etc...
cp2
0
Larry Brister
Asked:
Larry Brister
  • 2
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
what is the rowsource?
0
 
Larry Bristersr. DeveloperAuthor Commented:
capricorn1
The recordsource is from a stored procedure
ADODB.recordset
0
 
Gustav BrockCIOCommented:
The listbox always displays text.
You will have to adjust the stored procedure to produce the formatted output as strings as Format would do:

  Format(40, "0.00") => 40.00

/gustav
0
 
Larry Bristersr. DeveloperAuthor Commented:
Thanks
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now