converting a string to integer

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

accessing txt files 2
New Line Character 1
looping through a list box 1
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
String to Int32? 5
open a Microsoft Access form 4
GetMACAddress 1
running Access Queries 3

Top