Programming some nuances

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Two things:

1) How would I get a Label and Text box to appear only under conditions of a
different field being met? (I want a Deposit Date label & field to appear
only if DIRECTDEP=Y)

2) I have tried creating an unbound field for miscellaneous adjustments to a
financial report total. [Enter the Adjustment Amount (if any)] would be a
nice message. Then I need a grand total that takes the original report Net
Total and makes the user-prompted adjustment to it. If the user doesn't enter
anything, I still need a Grand Total.

Any thoughts?
 
Change the Control Source of tyour Desposit Date text box to:
=IIf([DIRECTDEP="Y"), [Deposit Date], Null)
You must also change its name to (say) txtDepositDate. Access gets confused
if it has the same Name as a field, but is bound to something different.

Right-click the attached label, and Change To | Text Box.
Then set its Control Source to:
=IIf([txtDepositDate] Is Null, Null, "Deposit Date:")

Note that if DIRECTDEP is a Yes/No field (not a Text field), you will need:
=IIf([DIRECTDEP=True), [Deposit Date], Null)
 
Back
Top