StrConv(CustomerRate, vbProperCase

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

StrConv(CustomerRate, vbProperCase

Post by burrina »

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

Code: Select all

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

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: StrConv(CustomerRate, vbProperCase

Post by HansV »

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

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: StrConv(CustomerRate, vbProperCase

Post by burrina »

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