Hi Friends,

How to enter blankspace to a field in a table
which is having data type as 'Number'

My issue is i am
taking values from a text box
to a variable of 'INTEGER' data type

This variable is then used to update a tablefield with 'NUMBER' data type

Dim ref as Integer
Dim intK as Integer

.
.

If (IsNull(Me("Text" & intK))) Or Me("Text" & intK).Value = "" Then
ref = ""
 Else
ref = Me("Text" & intK).Value
intK = intK + 1

After this i am updating a table
using DoCmd.RunSQL

While executing
data mis match error is coming on line marked red

Please help me on this

Thanks in advance


Dhaneshjs