SuperSnooper
asked on
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.
QuestC = InputBox("You have Entered " & Forms("ClientMaterials").[
and I want "[Average Cost per Unit] " it view as money.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER