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

In an Access 2003 db "Input Box", Format a Field view as Money

I have a "Input Box" in a command button Event Proceedure that I need the view of a Field value to be in money format. My "Input Box is:

QuestC = InputBox("You have Entered " & Forms("ClientMaterials").[Qunanty] & " Itens AT $" & Forms("ClientMaterials").[Average Cost per Unit] & "!" & "  Is This Correct?", "TYPE 'NO' TO CHANGE!")
 
and I want "[Average Cost per Unit] " it view as money.
0
SuperSnooper
Asked:
SuperSnooper
1 Solution
 
Luke ChungPresidentCommented:
Have you tried using the format command like this?

Format(Forms("ClientMaterials").[Average Cost per Unit] , "Currency")

Luke
0
 
SuperSnooperAuthor Commented:
Worked Perfectly...Great Job!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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