Tab into currency field only allows 1 digit. Arrow key OK?

[appelq]

I have a form - frmProducts
The Table is tblProducts with a field prd_Value
prd_Value is defined as Decimal, currency, 18 ,2
The field on the form is a Textbox, bound to the prd_Value field,Format= Currency, 2 decimal places.

The user is entering data and hits the Tab key to move through the fields. They Tab into the Value field on the form and want to enter 67 (for $67.00). The form only lets them enter the 6 and will not accept any more digits.

IF the user moves through the fields with the "Right Arrow" key, when they land on the value field, they can enter 67 just fine.

I do not have this problem entering data directly into the table, only when using the form.

Any ideas?

 

[TheAceMan1]

How are ya appelq . . .

[blue]prd_Value is defined as Decimal, currency, 18 ,2[/blue]

I have no idea what the above is suppose to mean but in the table just set the datatype to [blue]Currency[/blue].



See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[appelq]

It already is set to Currency.
"prd_Value is defined as Decimal, currency, 18 ,2"
The field in the table is named "prd_Value"
It set as a Number field, Decimal, format= Currency, Precision=18, scale=2, decimal places=2.

The form's Text Box is set to Format=Currency.

 

[TheAceMan1]

appelq . . .

I was simply thrown by your description of the [blue]Currency[/blue] data type. In access jargon [blue]Currency[/blue] would've been more than sufficient.

In any case [blue]I've never heard of or come across the condition you describe.[/blue] It appears to be indicitive of corruption. With that my 1st shot at this would be to [blue]delete then reinstantiate the textbox[/blue], by dragging/dropping the field from the field list.

Also by chance are you talking 2007?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]