Report Text box

S

Simon

I have a report that i would like to have some text with a delivery
day that is from the query the reportis based on

So i need a text box in the report somthing like below but it does not
work

= You parcel will be delivered on [DeliveryDay] at [Deliverytime]


Please can somesone tell me how i edit the code to work

Thanks

SImon
 
F

fredg

I have a report that i would like to have some text with a delivery
day that is from the query the reportis based on

So i need a text box in the report somthing like below but it does not
work

= You parcel will be delivered on [DeliveryDay] at [Deliverytime]

Please can somesone tell me how i edit the code to work

Thanks

SImon
Click to expand...

Any text must be enclosed within quotes.
Any field data must then be concatenated into the text, using the &
symbol.

= "Your parcel will be delivered on " & [DeliveryDay] & " at " &
[Deliverytime]
 
K

Ken Snell \(MVP\)

Use an expression similar to this as the Control Source of that textbox:

="Your parcel will be delivered on " & [DeliveryDay] & " at " &
[Deliverytime]


Note that you may want to use the Format function to display the two fields
in the correct format:

="Your parcel will be delivered on " & Format([DeliveryDay], "mmmm d\,
yyyy") & " at " & Format([Deliverytime], "h\:nn AMPM")
 
Top