Using strings that contain speech marks... 1

[djayam]

Hi all,

I am trying to speed up the performance of my db. One way is to define the source of controls in the OnLoad event of a form. I've hit a snag though. One of my controls is a textbox (ctl_DeliveryStatus) with the following CountrolSource:

=IIf([TotalQuantity]>[DeliveriesReceived],"DELIVERIES STILL OUTSTANDING","ALL DELIVERIES RECEIVED")

What do I type in the OnLoad event of the form as all those "" will obviously screw it up!!

Thanks loads,

Jason

 

[maxhugen]

There is nothing wrong with your ControlSource, although you'd need to ensure that the fields used have already been populated, that they aren't null, and that you're not dividing by zero.

Having sweated a lot over speed issues, I'm a bit skeptical that you'll see any improvement by 'unbinding' your form, although the form may open faster and 'appear' quicker to a user.

Max Hugen
Australia

 

[djayam]

Hiya Max,

It's the opening that is sped up and it's pretty noticeable.

In the OnLoad if I type

ctl_DeliveryStatus.ControlSource = "IIf([TotalQuantity]>[DeliveriesReceived],"DELIVERIES STILL OUTSTANDING","ALL DELIVERIES RECEIVED")"

it will error due to the "" screwing up the string. So how can I put " in a ControlSource?

Thanks,

Jason

 

[PHV]

ctl_DeliveryStatus.ControlSource = "IIf([TotalQuantity]>[DeliveriesReceived],""DELIVERIES STILL OUTSTANDING"",""ALL DELIVERIES RECEIVED"")"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[djayam]

Simple as that eh? Thanks PHV - I'll give it a try.