Prev: Sending a link for a form to the desktop - Access 2007
Next: Combo box that prints report
From: Tia on 13 May 2010 03:58
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
From: RonaldoOneNil on 13 May 2010 05:19
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 ?

"Tia" wrote:

> 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
> .
>
From: Linq Adams via AccessMonster.com on 13 May 2010 10:30
Ronaldo has hit the nail on the head here. Following his advice is the way to
go.

As he has suggested, a field that contains all digits but isn't used for
mathematical operations really should be defined as Text.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1

 | 
Pages: 1
Prev: Sending a link for a form to the desktop - Access 2007
Next: Combo box that prints report