help with auto enter.

[RET]

I am trying to figure out how I can have a word or value enter in a field automatically. However I would like to be able to change this value manually.

Can this be done?

Example: field1 has the word "active" automatically enter in every record. But If I wanted to change it to "un-active" I would like to change it manually.

Thanks,

RET

[mun]

If what I'm getting from what you are saying is right, you are looking for data to auto enter into a field and have the option of being able to change that field?

If that is the case, then just define the field to auto enter data (hit options button when creating the field) and when you place the field in your layout, just define the field format so that you are able to make an entry into that field (should be default setting).

I hope this helps, if this is not the case, let me know in a little more detail what you need.

[SMcGoo]

if you are only looking to enter two values into a field active and unactive. Why not create a field with a formula that looks into a date field example

create a date field called unactive date and then create a field with a calculation with the following formula

if(unactive date = "","Active","Un-Active")

this way the field will not alter until you enter a date in unactive date field.

I hope this helps...its just an alternative to your question