• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1425
  • Last Modified:

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.
0
lcha
Asked:
lcha
  • 5
  • 4
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Click into that form. On the Access menu >> Format>>UnFreeze All Columns.
Then File>>Save.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
" 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
0
 
lchaAuthor Commented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I'm talking about the main menu/tool bars at the top of the Access application window.

mx
0
 
lchaAuthor Commented:
sorry, I still don't see where format is.... please see screenshot attached.
top.png
0
 
lchaAuthor Commented:
not sure if it makes a difference, but i forgot to mention that I'm using MS Access 2007.  
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
lchaAuthor Commented:
ok, it's because all of the controls enabled properties are set to no.   I changed one of the controls to yes and went back to datasheet view.   Now the options to unfreeze all columns appears.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
cool.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now