Rotate Text and Select Nothing On Load

[John]

I have two questions. They may be so simple that no one ever asked, because
I can't find it in the post.

Firse, I have a form that displays information only. I have a print button
on it that prints a report that matches the form's information. The problem
is that when the form loads, one of the fields is selected. The form is
bound to a query. How do I tell the form on load to select nothing? Or,
tell the form that this is a view only and not to allow anyone to click in
the fields?

The second question relates to placing a label on the form, puting the a
caption in it like "COST", but then I would like to rotate it 90 degrees
counter clockwise. I can't seem to find a property for rotation. Is there
an easy way to do this?

 

[John]

Mike,

Thanks for the response... I have the lock on the fields set to "yes",
however this just prevents editing, not clicking in the field. When you
click in the field, the formating is removed and just the number is left. I
would prefer to make this form a mostly "no click zone" if possible (There is
a tab control on the form).

I am using the print preview when the print button is clicked, to show the
user what will be on the report. The form has a tab control on it with
different options, depending on what tab the user selects, drives the graph
that will be on the report. So it's a little more complicated than just a
print preview because there is some selectibility built into the form.

I have the
C
O
S
T
option on the form now, but would prever to see this like one would see on
the Y-Axis of a graph. I'll look into other options.

Thanks,

 

[fredg]

Mike,

Thanks for the response... I have the lock on the fields set to "yes",
however this just prevents editing, not clicking in the field. When you
click in the field, the formating is removed and just the number is left. I
would prefer to make this form a mostly "no click zone" if possible (There is
a tab control on the form).

I am using the print preview when the print button is clicked, to show the
user what will be on the report. The form has a tab control on it with
different options, depending on what tab the user selects, drives the graph
that will be on the report. So it's a little more complicated than just a
print preview because there is some selectibility built into the form.

I have the
C
O
S
T
option on the form now, but would prever to see this like one would see on
the Y-Axis of a graph. I'll look into other options.

Thanks,

Set each control's Locked property to Yes AND Enabled property to No.

 

[John]

Fred! That did exactly what I wanted... Any ideas on the vertical text?

 

[Dale Fye]

Check out Steve Leban's web site (http://www.lebans.com/). He has a lot of
formatting stuff like this, and, if I recall, there is something there that
will meet your needs regarding rotating text.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.