Lock out width/height adjust

[Gord]

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

[tina]

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

[Gord]

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

[tina]

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