Hi,

rs.Fields("InvoiceDate").Value = Format(Text3.Text, "dd-mm-yyyy")

The above code is written for the text box which shows the date.

Now, what I need is the code for Amount field which shows the invoice amount in the text box. How can it be modified to view like the below:

Rs. 5,000.25

Usually it shows the dollar sign but I don't need and also need to show the decimals also.

Please help.