Microsoft JET Database Engine Error '80040e14'

I'm getting this error
Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query _expression '123 street'.


The field in DB is type text. But the data to be written in the field is; number followed by characters. In other words it is an address field on the form, trying to insert new record into DB.


here is 3 different data I entered into field:


1. 'just some text' - works fine
2. 'text and number 123 ' - works fine
3. '123 number and text' - does not work. and gives the above error.
Anybody has any idea?