Fields in detail section of form

[PaulB]

Hi All,

In one of my applications, I have the following situation.

For a certain school activity to which all children can attend, some
children have to pay and some children can attend free. The background
and difference between these two groups is not relevant now.
In a (continuous) form, all these children are listed, sorted by class
and name. Listed fields are name, class ánd the sum to pay.

My question is about this amount-field. Even when a child doesn't have
to pay, this field is shown (with value 0). As you can imagine, I have
the wish that the user only sees this field if payment is necessary.
But: since I use a continuous form, a detail field is either always
visible or always invisible.
So the big issue is: is there any trick to handle this? I already tried
conditional formatting, but without succes.
Who can help me?

Kind regards,

Paul

 

[Ron2006]

Hi All,

In one of my applications, I have the following situation.

For a certain school activity to which all children can attend, some
children have to pay and some children can attend free. The background
and difference between these two groups is not relevant now.
In a (continuous) form, all these children are listed, sorted by class
and name. Listed fields are name, class ánd the sum to pay.

My question is about this amount-field. Even when a child doesn't have
to pay, this field is shown (with value 0). As you can imagine, I have
the wish that the user only sees this field if payment is necessary.
But: since I use a continuous form, a detail field is either always
visible or always invisible.
So the big issue is: is there any trick to handle this? I already tried
conditional formatting, but without succes.
Who can help me?

Kind regards,

Paul

Here is one approach that may give you an idea of how to handle it -
sort of depends on if they really have to use that field.

Change your source to a new query that has the prior as input and for
the fee field that they will see create a dynamic field that is the
following:

Fee: iif([queryname]![FeeName] = 0, "",[queryname]![FeeName])

Have the real fee still as part of the data of the resulting query,
but just don't put it on the form.

Ron