decimal figure in a field with access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Do Access table/form fields accept decimal figures ?
I need help please urgently too, I am sorry. I am working on a Form which
was created from a table and I just found out I couldn't input a decimal
value in a field. This field was set up with the data type of Number. No
matter how I make the setting in the Format, it just couldn't accept the
decimal value?! I am stuck there now and I have to present my data-base
tomorrow. I am stupid not thinking of that - during the test, I kept using
the round-up figures, i.e. no decimal.
Thanks a lot
 
Karen said:
Do Access table/form fields accept decimal figures ?
I need help please urgently too, I am sorry. I am working on a Form
which was created from a table and I just found out I couldn't input
a decimal value in a field. This field was set up with the data type
of Number. No matter how I make the setting in the Format, it just
couldn't accept the decimal value?! I am stuck there now and I have
to present my data-base tomorrow. I am stupid not thinking of that -
during the test, I kept using the round-up figures, i.e. no decimal.
Thanks a lot
Click to expand...

Change the "Field Size" of the field. You are currently using either
Integer or LongInteger which do not accept fractions. Use Single or Double
instead (or switch the type to Currency).

If you're now thinking that it is really confusing to subtype the "Number"
DataType by using the "Field Size" property you are absolutely correct.
Access is the only system I know of that does this.
 
It probably is either the data type in the table, or the input mask of the
text box. You defined the table field as number, but Integers and Longs do
not accept decimals, they are whole numbers only. It needs to be either a
Single or a Double. Also, check the input mask of the text box on your form
to ensure it is not prohibiting decimals.

One other thing, terminology. A field is not part of a form. A field is
an oject in a table. On a form, you have controls. One type of control is a
text box. It helps to use the correct terminology when referring to objects
so there is no confusion on what you are talking about.
 
Thanks a lot, Rick. this is it !!!

Rick Brandt said:
Change the "Field Size" of the field. You are currently using either
Integer or LongInteger which do not accept fractions. Use Single or Double
instead (or switch the type to Currency).

If you're now thinking that it is really confusing to subtype the "Number"
DataType by using the "Field Size" property you are absolutely correct.
Access is the only system I know of that does this.
Click to expand...
 
Thanks very much for your prompt response! you are my life-saver, indeed
that was the reason!
 
Back
Top