freezing culomn in access

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,
does anybody know if there is an option to freeze a culomn like its
been done in excel
one of the most problematic things in the form is when you have large
amount of data and it cannot be presented in one shot of the screen so
you need to scoll it,
but when the scroll is been done you still want to see the refrences of
the first culomn,

any ideas?
 
i'm referening off course to textboxes that should be freeze
thread ëúá:
 
After choosing the column that you want to freeze, go to the Format menu and
choose Freeze Columns
 
but what should be done if the form is not on a datasheet view?
is it still posible?
Arvin Meyer [MVP] כתב:
 
Not really since you are trying to keep the left side of the form
stationary and not the right side.

If you have designed a form that is that wide, may we suggest using a
main form with a tab control on the form and group the data on each of
the tabs in a logical manner.

Or have multiple occurances of the field that you want to see on the
form so that as you scroll right you can always see one of the
identical fields.

It usually is NOT a good idea to design a form so wide that it has to
be scrolled.

On the surface, without knowing your data, a tab control would seem
best with the header or part of the detail showing the common field and
the tabs having logically related information from the master record.

Ron
 
im not so sure I agree with this:

It usually is NOT a good idea to design a form so wide that it has to
be scrolled.


why not?
i think that it works great

there are definitely tradeoffs.. tell them they can either use
datasheet view and be able to hide columns; etc.. or form view.. you
can't do both

-Aaron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

crosstab query and dynamic report 5
Returning to previous record (if exists) instead of returning to the first record in a form after re 6
Freezing PC - New Motherboard - Suggestions? 15
PP 2007 Scroll wheel amount 1
Freezing column or section on a form 1
Excel Freezes 4
Port trunking on NAS using a Qnap QSW-M408-2C and a Qnap TS-239 Pro II 4
Can't access memory stick 6

Back
Top