Hi MS Access gurus,
This is probably a really simple answer for you but it has me perplexed and bamboozled :)
The table I am looking at has a number which is set to an integer and want it to be able to take 6 digits rather than 5. If you try this you get the error
The value you entered isn't valid for this field For example, you may have entered text in a numeric field...
If I change to a longint then it displays weirdly like 1.23456 E ...
I have tried changing to a string value because I don't believe any maths is done on the number but then I get a problem with the code
strCriteria = "[Number] = " & CStr(Forms!worker.[Number]) & " And [Number2] = " & CInt(Forms!worker.[Number2])
dbs.OpenRecordset("Worker", dbOpenDynaset).FindFirst strCriteria
I get error Run-time error '3464' Data type mismatch in criteria expression.
Obviously it doesn't make sense to do a CStr on a string so I removed that but still get same error
Basically all I need is a way to have the Number field to allow 6 digits like 123456 without bringin up an error in the quickest/easiest way possible.