Labels in forms

[Gostap]

I do have a problem with an Access application i dont have developed myself.
I have a form with several unbound subforms. The datasources in the subforms
is ordinarie tables.
The subforms is wiewed as datasheet.
Now the problem:
I cant change the capture on the fields labels. In the tabledesign I have set
the titles on the
fields and when i create a new form i do have the titles as i want to. But,
when i
wiewe the form as datasheet the capture of the labels will be the same as the
name of the fields datasource(even if
I change on the forms too).
As I said, I have not develope and create this database appl.myself.
Anyone able to help??

Sinc.

Gostap

 

[John Vinson]

I do have a problem with an Access application i dont have developed myself.
I have a form with several unbound subforms. The datasources in the subforms
is ordinarie tables.

I'm sorry, this makes no sense.

An Unbound subform HAS no recordsource. It's either unbound, or it's
based on a table - it can't be both!

The subforms is wiewed as datasheet.
Now the problem:
I cant change the capture on the fields labels. In the tabledesign I have set
the titles on the
fields and when i create a new form i do have the titles as i want to. But,
when i
wiewe the form as datasheet the capture of the labels will be the same as the
name of the fields datasource(even if
I change on the forms too).
As I said, I have not develope and create this database appl.myself.
Anyone able to help??

In table design you should be able to set the Caption property of each
field - that is what will be displayed.

I'm not fond of datasheet view; it's too limiting in some ways and too
free in others - users can conceal fields from view altogether for
example. Might you consider creating Continuous Forms, where you can
control your field labels completely?

John W. Vinson[MVP]

 

[missinglinq via AccessMonster.com]

I agree with all the points John made except:

"In table design you should be able to set the Caption property of each
field - that is what will be displayed."

The Caption property doesn't affect the headers in a datasheet form; it only
applies to the Label that automatically attaches to a text box when it's
placed on a form in Design View.

 

[John Vinson]

I agree with all the points John made except:

"In table design you should be able to set the Caption property of each
field - that is what will be displayed."

The Caption property doesn't affect the headers in a datasheet form; it only
applies to the Label that automatically attaches to a text box when it's
placed on a form in Design View.

Thanks, missinglinq. Shows how little I use datasheets!

John W. Vinson[MVP]

 

[missinglinq via AccessMonster.com]

I don't use them either! It amazes me the number of people I see here and on
other forums everyday who want their forms to look like an Excel spreadsheet!
The real kicker is that about nine out of ten of them are trying to do
something that would be much easily accomplished in Excel!

I agree with all the points John made except:

[quoted text clipped - 4 lines]

applies to the Label that automatically attaches to a text box when it's
placed on a form in Design View.

Thanks, missinglinq. Shows how little I use datasheets!

John W. Vinson[MVP]

 

[Gostap via AccessMonster.com]

I do have a problem with an Access application i dont have developed myself.
I have a form with several unbound subforms. The datasources in the subforms
is ordinarie tables.

I'm sorry, this makes no sense.

An Unbound subform HAS no recordsource. It's either unbound, or it's
based on a table - it can't be both!

The subforms is wiewed as datasheet.
Now the problem:

[quoted text clipped - 7 lines]

As I said, I have not develope and create this database appl.myself.
Anyone able to help??

In table design you should be able to set the Caption property of each
field - that is what will be displayed.

I'm not fond of datasheet view; it's too limiting in some ways and too
free in others - users can conceal fields from view altogether for
example. Might you consider creating Continuous Forms, where you can
control your field labels completely?

John W. Vinson[MVP]

I'm sorry, I was a bit hurry when i was writing; I mean, the "head" form
itself has no datasource if you dont called several subforms datasource. I
fully agree with your points not using spreadsheets, however i have not
create this database myself.
Even if you set captures on the fields in table design, the datasheet use the
same name of labels as the fields. But, normally you should be able to change
them in form design and they will be wieved as you wish even if they are
datasheets. I were able to change it in some forms (with subforms) in the
application, but not this particullary form. I have never seen this before
and thought it was made by code somehow but cant find it anywhere.

B.R

Gostap

 

[Gostap via AccessMonster.com]

[quoted text clipped - 20 lines]

John W. Vinson[MVP]

I'm sorry, I was a bit hurry when i was writing; I mean, the "head" form
itself has no datasource if you dont called several subforms datasource. I
fully agree with your points not using spreadsheets, however i have not
create this database myself.
Even if you set captures on the fields in table design, the datasheet use the
same name of labels as the fields. But, normally you should be able to change
them in form design and they will be wieved as you wish even if they are
datasheets. I were able to change it in some forms (with subforms) in the
application, but not this particullary form. I have never seen this before
and thought it was made by code somehow but cant find it anywhere.

B.R

Gostap

I've discovered a very strange thing with Access. If a create an ordinary
expressform in "column way", then i can change the labels in designmode and
wiew it as a datasheet and the change have taken affect. If a create a
expressform in "Tableway" i can change the labels and the changes take affect
as i just wiew it in tableway. If i wiew it in datashhet i am not able to
change the labels! Anybody know why??