finding the 'hidden' datasheet for editing on a split form access

[efandango]

using access 2007...

....How can I find the 'hidden' datasheet on a split form. I can see the main
form in the navigator pane, but not the accompanying datasheet. I ant to set
properties such as font style on the datasheet element of the split form, but
I cannot get to it as it seems to be hidden away, or does Access build it on
the fly when i open the main form?

 

[Linq Adams via AccessMonster.com]

I don't run v2007, but I suspect the same rules reign as in previous versions.
You can't do formatting to an individual Datasheet, nor even to the
Datasheets in an individual database, you can only set their formatting in a
installation of Access on an individual PC. The formatting will apply to all
Access apps run on that PC.In previous versions this was done thru the Menu,


Tools - Options - Datasheet.

If this is an app only you will be using, you can probably still set it up
this way on your machine. If this is going to be a distributed app, however,
I have to tell that fooling around with an individual user's settings is
generally considered to be very poor form.

Perhaps some of our more experienced developers here know how this can be
done using VBA, setting the formatting you want when opening the app, then
resetting it to the previous settings when closing.

 

[Tom van Stiphout]

On Sat, 20 Sep 2008 16:17:01 -0700, efandango

Set them in Layout view.

-Tom.
Microsoft Access MVP

 

[Tom van Stiphout]

On Sun, 21 Sep 2008 00:20:08 GMT, "Linq Adams via AccessMonster.com"

That's not true. Even in previous versions of Access you ran run a
subform in datasheet view as a main form, and apply formatting.

-Tom.
Microsoft Access MVP

I don't run v2007, but I suspect the same rules reign as in previous versions.
You can't do formatting to an individual Datasheet, nor even to the
Datasheets in an individual database, you can only set their formatting in a
installation of Access on an individual PC. The formatting will apply to all
Access apps run on that PC.In previous versions this was done thru the Menu,

<clip>

 

[Linq Adams via AccessMonster.com]

Actually, I was incorrect. Changing datasheet formatting in the Options -
Datasheet only affects the formatting in Table or Query display, not in forms
displayed in Datasheet View.

I assume that "Layout View" is something new in v2007, as it doesn't appear
in any version of Access I've used. In 2000/2003, you can do all the
formatting to a form you wish, in Design View, but if the form is run in
Datasheet View, the formatting simply doesn't show up.

The only formatting that does show in Datasheet View is Conditional
Formatting.

 

[efandango]

Tom,

you are correct, the subform/datasheet can be formatted in Layout View. But
for some reason, when I change the Font for a given field/column, it only
changes on the relative field on the main form section, but not the datasheet
view. I can change the fonts attributes, such as bold, italic, etc, but even
that changes all other columns too. but i cannot change the font, despite it
being shown in the properties window. does anyone know if this is a
limitation or a bug?