Re: Forms 3: query with non-numeric in number fields

In article <05DqPc2w165w_at_syntaxis.ukmail.net>, idixon_at_syntaxis.ukmail.net (Ian Dixon) writes:
> idixon_at_syntaxis.ukmail.net (Ian Dixon) writes:
>
> ...
> If a value such as '13%' is entered then I get the error. Without
> the test in the pre-query, forms will happily take this and do the
> query.
> ...

Excuse my ignorance.

I thought the % was only valid in a query on a character field. Does the above example mean any value beginning with 13 even in a number field??? Would the responses be 13, 130, 131...139, 1301, 1302, etc. ?????

Thanks in advance for your patient replies.

Bob

| Bob Schofield                   | If you want to worry less...              |
| G.D. Searle                     | Pray more!                                |
| 4901 Searle Parkway             | PHIL 4:6&7                                |
| Skokie, IL USA 60077            |                                           |
|                                 |                                           |
| EMail RJSCHO_at_SKCLA.MONSANTO.COM |                                           |
|_________________________________|___________________________________________|