Link to home
Create AccountLog in
Avatar of Sandesh555
Sandesh555Flag for India

asked on

Format number in Access Form

Hi Team,

I want to format all negative numbers coming up in Access in Red and in small bracket and the positive numbers with as usuall.

I am not able to check the same.  can you please help me on the same.

I have attached Access file in which I want the formatting to happen in the user form "Testing" in it for the sub form column "Open Amount".  I also want the text box Open Amount also formated in the same way.

I have attached excel file just in u have any question as to which format I am talking about.  the format is already applied in the thrid column of the attached excel file.

Thanks,
Sandesh jadhav.
Check-Payment-Format.xls
Check-Payment.accdb
SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account