Datasheet column formatting

T

triad

Greetings,
I would like to know if there is a way to format a datasheet so that the
viewer cannot hide columns and cannot move columns from the original format.
Any suggestions?
 
J

John W. Vinson

Greetings,
I would like to know if there is a way to format a datasheet so that the
viewer cannot hide columns and cannot move columns from the original format.
Any suggestions?

Use a Continuous Form instead. If the user doesn't have design privileges
(e.g. by using a MDE) they cannot move or hide columns; and the form can be
made to look very much like a datasheet if you (somewhat unaccountably) like
that appearance.
 
T

triad

I need to be able to switch from form view to datasheet view but I want to
keep the datasheet layout locked from any changes. Also, I don't have it
formated as an MDE due to various changes that need to be made. Any
suggestions?
 
J

John W. Vinson

I need to be able to switch from form view to datasheet view but I want to
keep the datasheet layout locked from any changes. Also, I don't have it
formated as an MDE due to various changes that need to be made. Any
suggestions?

Yes.

The one I gave earlier: don't use datasheet view at all. Instead use
Continuous view.
 
L

Larry Linson

I have used Access since its Version 1.0, and have never had a _need_ to
expose datasheet view to a user of a developed database application. One
reason there is no easy answer to your questions, I'd guess, is that the
Access developers knew that datasheet view was for end-user use, not
developed application use, and that end-users working ad hoc with their own
data would not need to be so constrained.

We seem to have a rash of people who post as if the approach they decided to
use to accomplish a result is by-gosh and by-golly the only way to
accomplish it, even if a more appropriate way is offered.

Is there some valid business reason why John's suggestion of continous forms
view Forms cannot serve your business requirements? It can, as he pointed
out, be made to look the same as datasheet view (or can be made to look
somewhat more 'polished').

Larry Linson
Microsoft Office Access MVP
 

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

Top