Automatic flag when fields are filled

[NicoCaldo]

Hi,


I'm setting up a database for my small activity and I would like to know if it was possible to create a field that automatically update itself with "yes/now" or check/unchecked if I fill specific fields of a table, or if it's simple, if I fills all the field of a table.
maybe is super easy but I'm new to Access
thanks to everyone will answer

[Minty]

You wouldn't normally store such a flag, simply calculate if the required fields have been completed.
If someone deleted a value anywhere in your system you would have to trap that event and then reset the flag.
As you can imagine that isn't very simple.

If a value really is mandatory then make it a required field in your table design.
You might be able to do it with a calculated table field, but I personally wouldn't recommend going down that route.

[NicoCaldo]

I don't want to make the field required because I would like to create item also if this field aren't filled. I need this "filled/u unfilled flag" because I'll fill this field in different moment but I want it all saved and I want to know what it miss and what it's ok.

the element created will never be deleted and, this table will be used only by me.

thanks for your help anyway

[Minty]

Okay - The flag will only tell you something is missing though, not what is missing.

If you insist on this the you would have to do it on a form, on the before update event of the form.
The simple code would be something like

Dim bFieldsComplete as Boolean

If Len(Field1 & "") < 1 OR Len(Field2 & "") < 1 OR Len(Field3 & "") < 1 OR Len(Field3 & "") ...etc etc THEN  bFieldsComplete  = False

Me.YourCheckField = bFieldsComplete

The more elegant way would be to loop around all the required field controls and check them based on a control tag being set to "Check" or similar.
That way you would only need to add a tag to any additional controls you added.