StrConv(CustomerRate, vbProperCase

[burrina]

Can't get my syntax correct Need to convert CustomerRate to currency

Code: Select all

Me.txtCustRate = DLookup("[CustomerRate]", "tblCustomers", "CustomerID=" & Me.CustomerID)

[HansV]

You don't need to do that in code. Set the Format property of the txtCustRate text box to Currency.

[burrina]

Duh, I forgot to look for that field on my form which was hidden.
Thanks,