INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Flicker on forms which have underlying calculated query fields

Flicker on forms which have underlying calculated query fields

(OP)
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.

RE: Flicker on forms which have underlying calculated query fields

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

RE: Flicker on forms which have underlying calculated query fields

(OP)
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.

RE: Flicker on forms which have underlying calculated query fields

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?

RE: Flicker on forms which have underlying calculated query fields

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close