Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quick Question - Function

Status
Not open for further replies.
101287

101287

MIS
Apr 8, 2006
189
US
Is there any function or vba code that I could use to change a text field with a currency format to numberic.

I have a text field numeric that I need to add to a numeric field and don't know how to do it.

Your help will be greatly appreciated.

Luis
 
Sort by date Sort by votes
I guess you mean that there is a currency symbol, dollar for example, in the text field. How about:
strCurr = "$25.00"
curCurr = Val(Mid(strCurr, 2))
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Split Function not working
Replies
3
Views
328
Kennelbloke
Kennelbloke
rdpress
  • Locked
  • Question
Question Open Shellling to File Explorer
Replies
3
Views
215
Andrzejek
Andrzejek
RolandR
  • Locked
  • Question
Access Rich Text Memo Field Question
Replies
1
Views
229
RolandR
RolandR
qqp
  • Locked
  • Question
Recall last settings function 2
Replies
8
Views
286
qqp
qqp
Moss100
  • Locked
  • Question
Function to strip all other than numbers from a field 1
Replies
5
Views
211
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top