By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,040 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,040 IT Pros & Developers. It's quick & easy.

Lock out width/height adjust

P: n/a
If possible, how can the user be prevented from adjusting the column width
and/or the row height in datasheet view (in VB code if necessary)? (I still
want them to be able edit the contents of the field though). I've got a
subform set up the way I like in datasheet view and I don't want to allow
the user to adjust either parameter.

Along the same lines, is it possible to eliminate the appearance of the
little drop down arrow next to the field headings that allows the drop down
menu for sorting/filtering?

Thanks,

Gord
Nov 8 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
i'm wondering if you're using A2007, if so my comments may not apply. if an
earlier version of Access, you can prevent the shortcut menu from showing by
opening the subform to Design view from the database window, where it is
listed as a separate form, and setting the ShortcutMenu property to No.

as for the subform datasheet columns, suggest you limit the user's closure
of the mainform to a command button that closes the form without saving
changes, as

DoCmd.Close , , acSaveNo

so the user can resize the subform columns, etc, at will, but the changes
will not be saved; so the next time the form is opened, your default setup
will apply. so presumably you're happy, and probably the user is a lot
happier, too.

hth
"Gord" <x1******@telus.netwrote in message
news:LSmRk.1203$A73.1184@edtnps82...
If possible, how can the user be prevented from adjusting the column width
and/or the row height in datasheet view (in VB code if necessary)? (I
still
want them to be able edit the contents of the field though). I've got a
subform set up the way I like in datasheet view and I don't want to allow
the user to adjust either parameter.

Along the same lines, is it possible to eliminate the appearance of the
little drop down arrow next to the field headings that allows the drop
down
menu for sorting/filtering?

Thanks,

Gord


Nov 9 '08 #2

P: n/a
Thanks Tina.

I am using A2007, but your suggestion for the ShortcutMenu property worked
just fine.

However, the 'SaveNo' option doesn't seem to have any effect. I've got a
command button on the main form that has the DoCmd.Close command that closes
the main form along with two subforms. I've tried variations (i.e. using a
DoCmd.Close for each of the subforms as well as the main form) and none
seems to make any difference. When the form/subforms open up, the column
widths are what I had left them at when last closed.

Anyway, its a small tweak that I was trying to apply and it's not that
important so I don't think I'll spend too much time trying to get to work
this way. I was just hoping there was some simple property setting like for
the ShortcutMenu that could be set.

Thanks again.

Gord
"tina" <no****@address.comwrote in message
news:oz********************@bgtnsc04-news.ops.worldnet.att.net...
i'm wondering if you're using A2007, if so my comments may not apply. if
an
earlier version of Access, you can prevent the shortcut menu from showing
by
opening the subform to Design view from the database window, where it is
listed as a separate form, and setting the ShortcutMenu property to No.

as for the subform datasheet columns, suggest you limit the user's closure
of the mainform to a command button that closes the form without saving
changes, as

DoCmd.Close , , acSaveNo

so the user can resize the subform columns, etc, at will, but the changes
will not be saved; so the next time the form is opened, your default setup
will apply. so presumably you're happy, and probably the user is a lot
happier, too.

hth
"Gord" <x1******@telus.netwrote in message
news:LSmRk.1203$A73.1184@edtnps82...
>If possible, how can the user be prevented from adjusting the column
width
and/or the row height in datasheet view (in VB code if necessary)? (I
still
>want them to be able edit the contents of the field though). I've got a
subform set up the way I like in datasheet view and I don't want to allow
the user to adjust either parameter.

Along the same lines, is it possible to eliminate the appearance of the
little drop down arrow next to the field headings that allows the drop
down
>menu for sorting/filtering?

Thanks,

Gord



Nov 9 '08 #3

P: n/a
hmm, well, you're welcome - i'm glad one suggestion was useful, anyway. as
for the subform Datasheet column widths, i haven't encountered that problem.
on the other hand, i've been developing almost exclusively in A97 for the
past 2+ years; maybe it's an issue in later versions of Access, and i've
just forgotten.
"Gord" <x1******@telus.netwrote in message
news:Q8JRk.1418$A73.1384@edtnps82...
Thanks Tina.

I am using A2007, but your suggestion for the ShortcutMenu property worked
just fine.

However, the 'SaveNo' option doesn't seem to have any effect. I've got a
command button on the main form that has the DoCmd.Close command that
closes
the main form along with two subforms. I've tried variations (i.e. using
a
DoCmd.Close for each of the subforms as well as the main form) and none
seems to make any difference. When the form/subforms open up, the column
widths are what I had left them at when last closed.

Anyway, its a small tweak that I was trying to apply and it's not that
important so I don't think I'll spend too much time trying to get to work
this way. I was just hoping there was some simple property setting like
for
the ShortcutMenu that could be set.

Thanks again.

Gord
"tina" <no****@address.comwrote in message
news:oz********************@bgtnsc04-news.ops.worldnet.att.net...
i'm wondering if you're using A2007, if so my comments may not apply. if
an
earlier version of Access, you can prevent the shortcut menu from
showing
by
opening the subform to Design view from the database window, where it is
listed as a separate form, and setting the ShortcutMenu property to No.

as for the subform datasheet columns, suggest you limit the user's
closure
of the mainform to a command button that closes the form without saving
changes, as

DoCmd.Close , , acSaveNo

so the user can resize the subform columns, etc, at will, but the
changes
will not be saved; so the next time the form is opened, your default
setup
will apply. so presumably you're happy, and probably the user is a lot
happier, too.

hth
"Gord" <x1******@telus.netwrote in message
news:LSmRk.1203$A73.1184@edtnps82...
If possible, how can the user be prevented from adjusting the column
width
and/or the row height in datasheet view (in VB code if necessary)? (I
still
want them to be able edit the contents of the field though). I've got
a
subform set up the way I like in datasheet view and I don't want to
allow
the user to adjust either parameter.

Along the same lines, is it possible to eliminate the appearance of the
little drop down arrow next to the field headings that allows the drop
down
menu for sorting/filtering?

Thanks,

Gord



Nov 10 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.