converting a string to integer

B

bbdobuddy

Hi,

How do I convert a string to an integer in Access.

Thanks in advance
bbdobuddy
 
A

Alex White MCDBA MCSE

Hi

something like

dim intTest as integer

if isnumeric(me.text1.value) then
intTest = val(me.text1.value)
end if

always check the value to make sure it can be converted first.
 
Top