Number fields in forms: Start as blank 2

[SALEEYOUNG]

I'm going completely brain dead on this so please excuse me if this seems like a really stupid question. I have three fields - two currency formats and one number format. When I open the form that has these fields - the form automatically fills the field with 0.00 data or else it fills these fields when I enter data in another field. Thus, when I reach that field - I have to delete the 0 numbers and fill in the correct amount. I can't seem to overwrite these fields, thus any numbers I enter just become extended from the 0's. How do I get the fields to be blank until I'm ready to enter data in those fields so I don't have to delete and refill information? I know it's something probably very simple that I'm doing wrong but any help would be ever so much appreciated. Thank you. Sandra

 

[Remou]

Hi
Have you looked at the Default Value for the fields in the table? Is that what you mean? The Default Value will also be set for the form.

 

[Knicks]

Number and currency fields when created at the table level have a default of "0". You simply delete any default property and they will start off blank.

I'm not sure why you are not able to write over the "0.00" though, as default is simply the default and shouldn't effect any data that is used to overwrite.

Are they bound fields? Meaning did you first create them at the table level and then add to a later form? It seems like you may also have the problem of using an unbound field, one simply added to a form but not created first at the table level.

 

[SALEEYOUNG]

Duh! It was the default value all right. How simple could that have been. Sometimes I just can't see the forest for the trees! Thanks to everyone who has helped me. It was truly appreciated.