Text field not showing visible/invisible correctly

[MarkGibson]

I have created a form that shows the user how much inventory is available at a given time for a given product or a category of products. They can then take an order for the quantity of the particular colour of product the client wants.

Because the size range can vary from inquiry to inquiry (i.e. S - M - L - XL - XXL one time and only A - B another time), I make the order entry fields visible (yes/no) and locked (yes/no) as needed to show only the proper number of columns, and only allow data entry if it is appropriate.

I set the field visibility in code, and the locked status in the OnCurrent Event.

Everything would be fine, except that often the field status is not reflected in what I see! For example, the entry field may not be visible to my eyes, even though it has been set as visible and unlocked, but I can tab to it and as soon as I enter data in it, it appears. Or a field has been made invisible but I can see it. When I scroll that section of the form out of sight and then back again, the presentation is fixed, and what I see is what I have coded. Any ideas why the display is not refreshing properly?

 

[RickBerem]

Hi,

Are you using a Continuous form? SG

 

[MarkGibson]

Hi,
Yes, it is a continuous form. There are no subforms, and because of the potential for 32 columns of size data, the form is very wide (a little over 2 screens of 1024 X 768). It can be from 1 record (about half an inch in depth) to 100 records long (vertically). So it is a big form!

Mark

 

[MarkGibson]

Maybe it is worth adding that when I move from one display to another, I change the recordsource of the form to an empty table, delete the records from my original display table, recreate the display table with the new data the user wants, and then change the recordsource back to the display table. I do this to avoid the screen filling with "###Delete###" messages in every field that has just been deleted. The data then displays correctly, but the visual presentation of the empty text fields that are waiting for data entry is often incorrect.

Mark

 

[RickBerem]

Hi,

I'm thinking that it might be because of your continous forms that your controls are displayed incorrectly. I think it's much like the issue of changing the backcolor of a control in a continuous form... one control affects all other instances of itself in the continuous forms.
I really don't know how you can fix that... but if someone knows that could be a great thing to share.

Sorry I can't help...
SG