Caption property concerning an unbound textbox

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Dear All,
in a report I need to insert a sentence, if a boolean field (EU) is true or
false.

My need is the following: if a sample is sent in EU (European Union), for
the custom, in the proforma-invoice (report) the incoterms must be
declatated.
Incoterms for EU: Delivery Duty Paid + Location
Incoterms outside EU: Delivery Duty Unpaid + Location

I though something of *automatic* and very easy, without building new fields
in tables, such as VB code, since the final user is not a power user.

If EU = True Then
Incoterm.Caption="Incoterm: Delivery Duty Paid "
Else
Incoterm.Caption="Incoterm: Delivery Duty Unpaid "
End If

but I am not able to find the Caption property concerning an unbound
textbox.
Does anybody can tell me if this method can run or if there is an
alternative procedure?
Many thanks in advance,
Marc
 
Textboxes (bound or unbound) don't have a Caption property. Labels have a
Caption property. You could change the text box to a label, change 'Caption'
to 'Value', or use an expression like the following as the Control Source of
the text box ...

= IIf([EU] = True, "Incoterm: Delivery Duty Paid", "Incoterm: Delivery Duty
Unpaid")
 
If your report is not based on a query than do so and add a field to the
query like:
EH1:=iif([EH]=0,"Delivery Duty Unpaid,"Delivery Duty Paid")
Then change the source on your report from EU to EU1
 
Thank you very much Reynolds!
I used the statement below and it works perfectly!!
Kind regards,
Marc
 
Back
Top