Setting a Constant Value for a Field

[Yzerman777]

In my form, I have a field where only a value 9.0 will be entered. I want to know if there is a way that I can have "9.0" entered automatically into this field when it comes up in the tab order. Thank you, in advance.

 

[nickjar2]

you place code in the on_Enter of the field

sub on_enter_fieldName

fieldname = "9.0"

end sub

or..

in design goto the properties of the field and enter 9 in the default value property.

Nick

 

[Bernadette]

Hi There

Set the default value of the field to 9.0 so that when you put in a new record, 9.0 will automatically be entered into the field.

Hope this Helps :-> Bernadette

 

[braindead2]

Good answers by both but this brings up the question, if the value is constant and will not change to anything but 9.0 why does it need to be a field in the database.