If condition

[AnnPhil]

I have a form with several date fields, i would like only the ones that meet the following condition to be visiable:
Between [Forms]![Date form]![Begin Date] And [Forms]![Date form]![End Date]

any suggestions???

Thanks in advance

 

[Mike375]

You use the visible property

FieldName.Visible = False

You then need to do an If

If whatever then

do this

End If

You would then place it on the OnCurrent event for the form. That means as you move to each record it will evaluate the situation and do what it does.

So you might have something like

If [Field]>[xyz] and [Field2] <[abc] Then

Or you can make a macro using Setvalue action.

Item is the field name with .visible added and No is the expression. In the condition column for each action you put in the condition (s) and then the macro is attached to onCurrent event