Report properties unavailable

[Guest]

When I am in the editing mode of a report, I am no longer able to see the
properties of a data zone. When I click on properties, all zones are called
labels even if they are data. The reports look fine, but I can't modify the
properties any more. What have I done and what can I do? Please help. P.S.
This problem does not occur in forms.

 

[Guest]

What do you mean by "data zone"? I'm not familiar withthat terminology and
Access database mdb files.

 

[Guest]

...
I'm sorry about the terminology since my program is in French. In a report,
I have two kinds of fields. There are fields that are only labels and there
are fields that contain data. I actually have the problem of not being able
to see the properties of the field whether is is a label or whether it
contains data.
Thanks

 

[Guest]

Now I understand. Your English is better than my French.

In the report design view, right click on the text box and bring up
properties. Go to the Data tab. If it only says Smart Tag, it's probably a
label. If you see Control Source and a few others, it's probably a text box
control.

Also look at the top of the Properties window.
It should say something like Label: Owner if it's a label and Text Box:
Owner if it's a text box.

 

[Guest]

I appreciate your explaining how to know about the properties. However, I've
been using the program for many years and have not ever had this problem
before. I have always simply clicked on "properties" and got a list of the
properties that I could change.

Now, when I click on "properties", something different happens. I get a
single line which tells me that this is a label or that this is text and then
it gives me the name of the field. In a pull-down box just below, I am given
the name of the field again, but no other options.

This seems to be a glitch in the program. Even when I uninstalled the
program and re-installed it, the same thing happened. When I created a new
report, it kept happening. What I want to know is if anyone else has had the
problem and can it be solved?

Thanks so much for thinking with me

 

[John Vinson]

Now, when I click on "properties", something different happens. I get a
single line which tells me that this is a label or that this is text and then
it gives me the name of the field. In a pull-down box just below, I am given
the name of the field again, but no other options.

To view the properties *OF THE REPORT AS A WHOLE*, right mouseclick on
the little square at the upper left intersection of the rulers in
report design view, and select Properties.

It appears that you're looking at the properties of a label on the
report - not the properties of the report itself. As you see, labels
don't have very many interesting properties...!

John W. Vinson[MVP]

 

[Guest]

Thank you John for trying to understand. It really is the properties of the
individual fields in the report that are giving me problems. Again... when I
rightclick on the field and then select properties, the properties are not
displayed. As I see it, there may be some protection feature that I clicked
on inadvertently that keeps me from seeing the properties so I won't change
them. Or maybe in replication that is what happened (although in the forms,
I'm not having the problem).

 

[John Vinson]

Thank you John for trying to understand. It really is the properties of the
individual fields in the report that are giving me problems. Again... when I
rightclick on the field and then select properties, the properties are not
displayed. As I see it, there may be some protection feature that I clicked
on inadvertently that keeps me from seeing the properties so I won't change
them. Or maybe in replication that is what happened (although in the forms,
I'm not having the problem).

It almost sounds like you have a MDE, or a Runtime instance of Access,
or that you're inadvertantly opening the database with the runtime
switch... wierd!

The only alternative I can suggest is that the report is corrupt. Can
you design other reports? Do you know the trick of
Application.SaveAsText to write the report out to disk, and
Application.LoadFromText to read it back in (after compacting)?

John W. Vinson[MVP]

 

[Brendan Reynolds]

You mentioned replication. I don't know a great deal about replication, but
I understand that when an MDB is replicated, design changes can be make only
to the design master, not to any of the other replicas in the replica set.
Could this be the problem?

 

[Douglas J. Steele]

Replicated databases shouldn't have Forms or Reports in them: replication is
only intended for Tables.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)