If the only thing that field can accept is numbers only, use an
InputMask on the field.
Defining the datatype will still allow them to enter letters, but I
think it will throw an error when they leave that field if they typed
in something that the datatype in the table won't allow. (such as a
letter in a Number datatype field)
le******@austarnet.com.au (Laurie) wrote in message news:<fe**************************@posting.google. com>...
"PC Datasheet" <no****@nospam.spam> wrote in message news:<oq*****************@newsread2.news.atl.earth link.net>... Notice that Doug's example is "D2" ---
2 Decimal places
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Salad" <oi*@vinegar.com> wrote in message
news:V2*****************@newsread1.news.pas.earthl ink.net... Douglas J. Steele wrote:
> Just be aware that things like 123E4 and 543D2 will be found as Numeric by > the IsNumeric function.
>
> (1230000 and 54300 respectively)
>
Interesting. I can understand somewhat the E4 thinking the power of.
What is the "D"?
Thanks for all the replies. Just after posting the message I realised
that defining the datatype was all I needed however the comment on
IsNumeric took me by surprise. It is amazing what a seemly simple
question can raise.
Thanks
Laurie