A Adriano85 Registered User. Local time Yesterday, 20:23 Joined Jan 16, 2013 Messages 16 Apr 4, 2013 #1 Hi guys, What is the best function to turn a currency field €10,00 into a text field like 1000? Many thanks! Adrian
Hi guys, What is the best function to turn a currency field €10,00 into a text field like 1000? Many thanks! Adrian
pr2-eugin Super Moderator Local time Today, 04:23 Joined Nov 30, 2011 Messages 8,487 Apr 4, 2013 #2 Hello Adrian, you could use CLng() function to change it to Number.. If you really need to treat it as a String then wrap the output of CStr or Format
Hello Adrian, you could use CLng() function to change it to Number.. If you really need to treat it as a String then wrap the output of CStr or Format
A Adriano85 Registered User. Local time Yesterday, 20:23 Joined Jan 16, 2013 Messages 16 Apr 4, 2013 #3 Thanks mate! Cstr([fieldname])*100 Did the job. Amount in cents as a string.
