displaying information in a table

  • Thread starter Thread starter Guest
  • Start date Start date
RMERCADO2078 said:
How do I turn a text string in a form into a numeric value in a table?
Click to expand...

Generally Access will automatically accept a string that is a representation of
a number as a valid entry in a numeric field without an explicit conversion so
long as it is within the size of the field in question. If you want to
explicitly make the conversion you can use whichever of the following is
appropriate.

CDbl(expression)
CDec(expression)
CInt(expression)
CLng(expression)
CSng(expression)
 
Back
Top