DataSheet View Format

[MVP - WannaB]

Hello, Is there a way to control the format of a form when it is displayed as
a datasheet ?
Every change I make to the properties only works if I display the form in
form view, it's like the properties are useless, but I'm sure there must be
something (ELSE) that i don't know.
I appreciate any help you can provide, Thank you.

 

[John W. Vinson]

Hello, Is there a way to control the format of a form when it is displayed as
a datasheet ?

Not really. If you want to control the appearance... you can't use a
datasheet; datasheets have VERY limited flexibility.

Consider using Continuous view instead; this can be made to look very much
like a datasheet, if you like the appearance, but you get the flexibility to
change the format and appearance of individual controls.

 

[Ron2006]

Wannabe

In datasheet view
you can change sequence and size of all fields dynamically.
You can change color and enabled properties, via conditional formatting.

You can change locking via code and all other behind the scenes code will
function as if on a continuous form.

dropdowns will work a little better in some situations in datasheet than
they do in continuous.
I am not sure about conditioned invisibility when in continuous format,
there may be incongruities although in datasheet it will NOT work at all.

Just have to try working with it.