weird problem with field in form

[sk88]

I am unable to enter numbers to a field like .50 or .63 and so on. The field won't allow me to enter '.' and if I type in .23, it will give me 32


The field is acting weird and goes backward.

The field is called RATE and it is in - NUMBER, LONG INTEGER, AUTO DECIMAL

I have tried - DOUBLE and it won't work as well.

Thanks

[pbaldy]

Long Integer will not hold a decimal value (hence the name integer). Double should, as should Currency. What happens when the data type is one of those?

[sk88]

Long Integer will not hold a decimal value (hence the name integer). Double should, as should Currency. What happens when the data type is one of those?

Thanks for your help. I did try changing it to Double. the error produced seems to be the same. When I type 25 in the form...the field gives me 25 and I get an error message. please see attached

[pbaldy]

That's an odd one. If you create a new form based on the table, can you enter the data? I wonder if that form got corrupted.

[John_G]

That does not look like a standard error message from MS Access. Access will not ask you to call your network administrator, because in many cases it isn't even on a network. You might also want to scan your computer for malware - that error message looks a bit suspicious from that point of view as well.

For the field that is giving you problems - what are the settings (if any) for input mask or validation rule?

Are there any form or control event procedures that might produce this error?

[sk88]

That's an odd one. If you create a new form based on the table, can you enter the data? I wonder if that form got corrupted.

Yea..I still can't understand why the numbers I type goes backward. The rest of the fields look fine though. Could it be version issue? This database was built like 10 years ago and I added the new fields recently.

[sk88]

That does not look like a standard error message from MS Access. It does not ask you to call your network administrator, because in many cases it isn't even on a network. You might also want to scan your computer for malware - that error message looks a bit suspicious from that point of view as well.

Thanks John!

For the field that is giving you problems - what are the settings (if any) for input mask or validation rule?

Are there any form or control event procedures that might produce this error?

It could be the control event procedures. I'll check again.

I have a code back-end that will give me values which I can edit...

Field A AFTERUPDATE is 
Rate = (Field A+ FIELD B+ FIELD C)/180

Field B AFTERUPDATE is 
Rate = (Field A+ FIELD B+ FIELD C)/180

Field C AFTERUPDATE is 
Rate = (FIELD A+ FIELD B+ FIELD C)/180

There is no coding in RATE field and RATE field is editable. This is where I am having the error. Could that be the problem?

[pbaldy]

It doesn't sound like a version issue. Can you post the db here?

[ssanfu]

If you really have fields named Field A, Field B and Field C, you are missing brackets.

Rate = ([Field A] + [FIELD B] + [FIELD C])/180

Should never use spaces, punctuation or special characters (except the underscore) in object names.

[sk88]

If you really have fields named Field A, Field B and Field C, you are missing brackets.

Rate = ([Field A] + [FIELD B] + [FIELD C])/180

Should never use spaces, punctuation or special characters (except the underscore) in object names.

Thanks ssanfu! I do have the brackets - sorry, I should have mentioned that earlier.

It doesn't sound like a version issue. Can you post the db here?

I'll try to post the db here soon. I need to delete my old data first as they are confidential data.