Access 2007 vba convert text to decimal

I have several text (50) records that are imported thru an ODBC connection that reads ie 32.9.   I would like to convert to a number with one decimal point.   How do I convert it in VBA.
glomo82Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
CSng(YourField)  to be exact
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
csng("32.1")
returns
32.1 numeric

mx
0
 
GRayLCommented:
CDbl(myFld,"#.0")
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
But why change to Double that takes the storage ?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
> That takes twice the storage ?
0
 
GRayLCommented:
I was never told the value could not exceed 32768
0
 
glomo82Author Commented:
Thanks a bunch
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.