Dear Richard,

Can you explain how to format currency or number like 235,4575.23 and Align to right. All list box in Access payable Seminar lesson.  If I use CCur(FiledName) It formatted with $ sign I cannot use $ sign for local currency for Rupees.

I have set all currency Field, Data Type   Number, Field Size   Double, Format   Standers, Decimal Places   2 . I tried VB Code Amount Due like this Format( AmountDue ,  ###,###.00) But it Did not come right.

Can you please explain how to format Numbers and Date also like dd-mmm-yy to right Align.

Thank you
Kalyana

---

Reply from Alex Hedley:

What is 'Region and Language' set in Control Panel?

You can set the alignment of a Field in the Ribbon.
Select your Textbox, go to the Form Design Tools | Format and select the Align Right option.

For the DateFormat drag your Date/Time Field onto the Form, then in the Format Tab of the Property Sheet type in the Format you want (dd-mmm-yy)