Flicker on forms which have underlying calculated query fields

[Moss100]

Hello, I have been trying to limit the amount of flicker which occurs on forms.

In instances were I use a tab control AND have the form based on a query which has a calculated field, I notice there is a substantial amount of flicker.

I have worked out that the flicker occurs when updating a field value which is used in the calculated expression.

I.e. I concatenate a clients name in the query. If I change say the first name it will cause the form to flicker. If I change a field which is not directly used in the calculated field then no flicker occurs.

I have tested this on new forms, so it seems to be a bug in access. Just wondering whether there is any way around this?

Many thanks Mark.

 

[MajP]

I would goggle this. There is a lot of information, but very release dependent.

 

[Moss100]

Yes I have, but arrived back here!!

It's defiantly linked to the calculated field in the query.

I've tried all the usual suggestions such as unbound labels etc.

Thanks anyway.

 

[MajP]

What version of access?
What version of Windows?
Are all service packs up to date?
Do you have conditional formatting?
What happens if you calculate in the control and not the query?

 

[Moss100]

What version of access? 2013
What version of Windows? Win 7
Are all service packs up to date? Yes
Do you have conditional formatting? No
What happens if you calculate in the control and not the query? No flashing.

Thanks Mark