Controling Column Headers and Column order in subform -- How?

P

plh

Hi,
I have a form/subform arrangement in which the subform is in data-sheet view.
I need to do one of two things:
1) Control the name that appears on the column header. It matches the control
name on the form, but that is often something ugly like "cbxToolHolder" where I
want it to be "Tool Holder" (which has a space & so is not so good for an
internal code reference. And, I have a lot of that.)
2) Just make the column names not show. Then I can put my own labels above each
one. The reason that would not be as good is that it users could then miss-align
the columns and the labels.

The other problem is that I want to re-arrange the order of the columns, and I
can't seem to figure out how to do that. How does one do that?

Thank You!
-plh
 
C

Chris

1) Control the name that appears on the column header. It matches the control
name on the form, but that is often something ugly like "cbxToolHolder" where I
want it to be "Tool Holder" (which has a space & so is not so good for an
internal code reference. And, I have a lot of that.)
Click to expand...

Change the label of the control in question
The other problem is that I want to re-arrange the order of the columns, and I
can't seem to figure out how to do that. How does one do that?
Click to expand...

Select the column and drag and drop it over.

HTH

Chris
 
P

plh

None of those actions have any effect. I tried starting off a new form wizard &
selecting "datasheet" as the layout and it still had no effect. I can move the
columns around on the form view but then in the datasheet view nothing happens.
Changing the column label also has no effect on what shows up on the datasheet
view.
Thanx,
-plh
 
J

John Nurick

A lot of people just create continuous forms that look the same as
datasheets. That way you have full control.
 
Top