Form text box control flickers

[PNGBill]

Hi Forum, Access 2000
A continuous form includes a control for Email and another for SMSText
The form record source is

NZ([ADEmail],"None") AS MemEmail

- extract
Control source is

=IIf([MemEmail]='None',"No Email","Email Repay Advice")

And then Conditional Formatting disables the control if "No Email" is the field value.
Similar for the sms text control.

Could it be just so many things to do that causes the flicker??

Most forms only have 2 to 6 records so you wouldn't imagine it over taxes the system that much.

Any ideas what can cause the flicker just in the two controls, not the whole record in the continuous form.

Thanks, Bill

 

[vbaInet]

Have you tried putting the calculation in the query instead of the control source?

Also try detaching the label from the textbox and see what happens.

Do you have subforms within the form? What kind of controls do you have?

 

[PNGBill]

Thanks vbaInet,

Have changed the query to this

IIf([ADEmail] Is Null,"No Email", "Email Repay Advice") AS MemEmail

Removes one step and all seems to work fine now.

Continuous Form is a subform. Invoice Header & Invoice Detail style.
Only main form and subform.

No label for these controls as they are self explanatory.

Used the same system on another form and no problem but this seems to be resolved.

Thanks again.

 

[PNGBill]

We had two instances of the same system yet one flickered and the other didn't.

I realise now the flicker example was on a continuous form where we enter data and the last record displayed is "empty" waiting for data to be added.
This record also flickered and actually displayed the format if there was an email address where as there is no record so no address should be available.
Could this be the difference between Null and Empty ??

When I removed the IIf in the form control record source both the flicker ceased and the empty record displayed nothing, as it should.

In the example where we had no problem, the continuous form displays data only and does not allow new records to be added and there is no record with Empty fields.

does this explain why we had the flicker??

Thanks,
Bill

 

[vbaInet]

Could this be the difference between Null and Empty ??

Here's an article from pbaldy regarding the differences between Null and Empty:

http://baldyweb.com/NullEmptyEtc.htm

When I removed the IIf in the form control record source both the flicker ceased and the empty record displayed nothing, as it should.

In the example where we had no problem, the continuous form displays data only and does not allow new records to be added and there is no record with Empty fields.

does this explain why we had the flicker??

Thanks,
Bill

Sometimes if there's much going on on your form and you have calculations in control sources (especially if the calculations are dependent on a field in the record source) it may cause it to flicker. For everytime a calculation is done on a control the control calls its repaint method twice and it's during the repaint the flicker can happen. So if all your control is doing is displaying already calculated data it will only call the repaint method once in sync with the other controls.