Textbox on form won't display currency format

[hunoob]

Hi Everyone! I have a very basic problem but (as I am a beginner can't really solve it). I have a form with a textbox on it. The textbox is called txtAmount and it should display the number in currency format (the table column is set to currency format and the textbox itself is also set to currency format) however it displays the currency as number. What am I doing wrong?

(Please see the files attached)

Please try to help me if you can. Thank you in advance!

 

[vapid2323]

Using bound controls works fine when I messed around with this, I have no idea why unbound ones wont.

Is there any reason you cant just use bound controls?

 

[hunoob]

Hi vapid2323!

I need it unbounded as I have other data which are query data and cannot bound them to the list selection. I would need it unbounded!

Please try to help if you can! I really do not understand why I cannot set the format to currency...

 

[hunoob]

Please try to help if you can!!!