cant type more than 11 numbers

T

Tia

Dear all,
I have a bank account that contains more than 15 numbers, whenever i
am trying to make the data entry ex :4322386920125206 i am receiving
that
the value you entered isnt valid for this field for example you may
have entered text in a numeric field or that number is larger than the
field size setting permits please help
my data type is number ,filed size long integer, decimal places:auto

Please help
 
R

RonaldoOneNil

A long variable can hold a maximum number of 2147483647
I suggest you make your bank account number field text. It does not need to
be a number just because it contains all digits. You are not going to perform
calculations with it are you ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Long Integer field size 11
HOW TO MOVE FOCUS TO ANOTHER FIELD IN A FORM 1
Access Access DLookup Function – more than 1 criteria 0
Date-time field in data entry form 3
Digits on right of Decimal points 1
Limiting text data type to numeric input 1
drop-down error 1
Date Format/ Input mask 1

Top