Solved Any way to prevent textboxes from flickering?

[gojets1721]

In my single form, any textbox that uses an expression flickers when changing records. These aren't calculations either; I use a few textboxes as labels so it's just ='Label' in the textbox's control source. Still flickers.

Any suggestions on if that can be fixed?

 

[theDBguy]

If they're fixed values, you can just assign them using VBA when the form opens.

 

[gojets1721]

If they're fixed values, you can just assign them using VBA when the form opens.

That worked!! Thanks so much.

 

[theDBguy]

That worked!! Thanks so much.

Glad to hear you got it to work. Good luck with your project.

 

[gojets1721]

Glad to hear you got it to work. Good luck with your project.

Thank you. Somewhat related question...these textboxes are basically used as labels. I was always taught that unassociated labels should just be converted to textboxes for better form efficiency, so that's what I've done. Is that still the case? Cause obviously just using labels is far simpler.

 

[cheekybuddha]

I was always taught that unassociated labels should just be converted to textboxes for better form efficiency

I've never heard that before.

Can you explain further, or provide a reference?

 

[theDBguy]

Thank you. Somewhat related question...these textboxes are basically used as labels. I was always taught that unassociated labels should just be converted to textboxes for better form efficiency, so that's what I've done. Is that still the case? Cause obviously just using labels is far simpler.

I don't do that. I use labels, if I need labels. I use textboxes, if I need textboxes.

 

[gojets1721]

I don't do that. I use labels, if I need labels. I use textboxes, if I need textboxes.

Gotcha! I'll do that

 

[gojets1721]

I've never heard that before.

Can you explain further, or provide a reference?

I'm not certain 100%. I've done it for a while. I think it was due to an unassociated label glitch in earlier Access versions. See here:

Microsoft Access tips: Flicker with tab controls

Explains a problem in Microsoft Access 2003, where forms flicker as the mouse moves over them. Contains code to work around this issue.

allenbrowne.com

Either way, I am wrong. I am going to convert all mine back to labels.

 

[cheekybuddha]

I'm not certain 100%. I've done it for a while. I think it was due to an unassociated label glitch in earlier Access versions. See here:

Microsoft Access tips: Flicker with tab controls

Explains a problem in Microsoft Access 2003, where forms flicker as the mouse moves over them. Contains code to work around this issue.

allenbrowne.com

Either way, I am wrong. I am going to convert all mine back to labels.

Thank you for posting that link.

It appears that it only applied to a specific situation (unbound labels on tab controls) and was fixed in Acc 2k7.

Interesting, nonetheless.