lcha
asked on
form datasheetview, columns are frozen. How to unfreeze them
Hello experts,
I have a form (#1), with a subform (form #2 is the source) on it. This subform has multiple textboxes in it and is bound to a table in the database. I have the default view for it set to datasheet ...
When I open up form 1, form 2 displays in the subform in datasheet view.
Somehow I seem to have frozen the first three columns in this datasheet on the subform or Form # 2. I want to unfreeze these columns.
When I checked the table that the form #2 is bound to, nothing is frozen so I'm wondering if this is something specific to the properties of the controls on form #2. I need some guidance here.
thanks in advance for your help and please let me know if you have any questions or need clarification.
I have a form (#1), with a subform (form #2 is the source) on it. This subform has multiple textboxes in it and is bound to a table in the database. I have the default view for it set to datasheet ...
When I open up form 1, form 2 displays in the subform in datasheet view.
Somehow I seem to have frozen the first three columns in this datasheet on the subform or Form # 2. I want to unfreeze these columns.
When I checked the table that the form #2 is bound to, nothing is frozen so I'm wondering if this is something specific to the properties of the controls on form #2. I need some guidance here.
thanks in advance for your help and please let me know if you have any questions or need clarification.
" so I'm wondering if this is something specific to the properties of the controls on form #2"
Yes ... it should be specific to the datasheet form itself.
mx
Yes ... it should be specific to the datasheet form itself.
mx
ASKER
On the Access menu >> Format>>UnFreeze All Columns.
Then File>>Save.
apologies but can you clarify where is the "Access menu" is? I am able to find "format" as a property sheet of the form but I don't know specifically what you mean by the Access menu, couldn't "unfreeze all columns" on any control property.
I tried looking viewing the form in datasheet view, right clicking on one of the frozen columns, but unfreeze columns is disabled.
thanks for clarifying.
unfreeze.png
Then File>>Save.
apologies but can you clarify where is the "Access menu" is? I am able to find "format" as a property sheet of the form but I don't know specifically what you mean by the Access menu, couldn't "unfreeze all columns" on any control property.
I tried looking viewing the form in datasheet view, right clicking on one of the frozen columns, but unfreeze columns is disabled.
thanks for clarifying.
unfreeze.png
I'm talking about the main menu/tool bars at the top of the Access application window.
mx
mx
ASKER
sorry, I still don't see where format is.... please see screenshot attached.
top.png
top.png
ASKER
not sure if it makes a difference, but i forgot to mention that I'm using MS Access 2007.
Well, I see it's A2007 now. You need to find the Format options; however re:
"but unfreeze columns is disabled. "
That seems odd. If you just open this form normally from the database window ... and right click ... is that option still grayed out?
mx
"but unfreeze columns is disabled. "
That seems odd. If you just open this form normally from the database window ... and right click ... is that option still grayed out?
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Then File>>Save.
mx