Hard to handle

[Dan Goble]

I am still working on populating a contract from form to report.

There are several lines in the contract that cant be changed that look like
this

Please list inclusions and exclusions ______________________________________
___________________________________________________________________
____________________________________________________________________


I place a control box over the lines and make it transparent but obviously
the text either covers the "Please etc."
Or if i size it to fit the end of the line the second line margin starts too
far to the right.

btw: fredg
I want to express my appreciation for your prompt replies. Everything is
working great due to your efforts. Its really nice to see someone so
helpful
If you ever need info on real estate or private investigation I am your
contact.
Thanks
Dan

 

[Allen Browne]

Try a text box with Control Source of:
= "Please list inclusions and exclusions " & String(200, "_")

Adjust the box so it's 3 lines high (or whatever you need.)
Any extra characters just get ignored.

Any yes, fredg has contributed to many people's successes.

 

[Dan Goble]

I wasnt clear enough or I dont understand your approach which is likely:

Your suggestion works perfectly to put the text in the report except that
text is already there. I want to take the text that was entered into the
form and stored in the field, to the report which already has "Please
etc.__________" on the report. I want to place the control box which
displays that info over the Please etc. I cant put anything in the control
box on the control that fits into the report because it is filled with the
field info.

 

[Dan Goble]

Try a text box with Control Source of:
= "Please list inclusions and exclusions " & String(200, "_")

Adjust the box so it's 3 lines high (or whatever you need.)
Any extra characters just get ignored.

Any yes, fredg has contributed to many people's successes.

 

[Allen Browne]

Okay, thanks for clarifying. So you are trying to give an underlined effect
to the text the report is reading from a field.

You can do that in Access 2007 quite easily, by using a rich text box on the
report. The control source would be:
="Please list inclusions and exclusions <u>" & [SomeField] & "</u>"

It should be possible to place the text box with the lines behind the one
that contains the text if you set the background style to transparent.

Post back if it still isn't working.

 

[Dan Goble]

"Please list inclusions and exclusions" and the lines that I previously
showed are already displayed on the report. Dont need any underlines or the
Please text. I just need the field that displays to have 100 spaces before
the field starts to display so I can pass up the "Please text in the report
and then I will move the transparent field up or down to fit the existing
lines. The field text will auto return at the end and go to the next
existing line. The contract (report) has to have the text and all the lines
in the case that I leave it blank and do sometimes.

Report (lines are there already)

Please list inclusions and exclusions
______________________________________
___________________________________________________________________


This is the control box that is transparent and sits on top of the above in
the report and doesnt start until after the word exclusions
I have already made this work by hand. I just typed in the 100 spaces on
the form then wrote some sample text

(space space space etc.---------------)[This is text from the field that
will auto return
Now I am still sitting on top of the lines on the second line in the report.

The spaces could cover the Please text? if so it is no problem to write
something or set something in the form field so the typist starts at 100
spaces. Its a memo field that scrolls so the user will never know he is
actually starting at the end of a 100 spaces

Okay, thanks for clarifying. So you are trying to give an underlined
effect to the text the report is reading from a field.

You can do that in Access 2007 quite easily, by using a rich text box on
the report. The control source would be:
="Please list inclusions and exclusions <u>" & [SomeField] & "</u>"

It should be possible to place the text box with the lines behind the one
that contains the text if you set the background style to transparent.

Post back if it still isn't working.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I wasnt clear enough or I dont understand your approach which is likely:

Your suggestion works perfectly to put the text in the report except that
text is already there. I want to take the text that was entered into the
form and stored in the field, to the report which already has "Please
etc.__________" on the report. I want to place the control box which
displays that info over the Please etc. I cant put anything in the
control box on the control that fits into the report because it is filled
with the field info.

 

[Allen Browne]

Sorry, Dan, I'm not sure I understand the problem. Perhaps someone else can
jump in and help us.

I'm confused by your comment at the end. Since you posted to the Reports
group, I assume we are talking about a printout here, and you just want the
text in the text box to print out at the right place. The typist can't type
into the report though -- well, not unless you are talking about the new
report view in Access 2007 perhaps?

I can follow the idea of a text box on a *report* that is bound to an
expression such as:
=Space(100) & [SomeField]

Of course, if the user has been entering that record in the form, the record
in the form will need to be saved before it will turn up on the report
correctly.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"Please list inclusions and exclusions" and the lines that I previously
showed are already displayed on the report. Dont need any underlines or
the Please text. I just need the field that displays to have 100 spaces
before the field starts to display so I can pass up the "Please text in
the report and then I will move the transparent field up or down to fit
the existing lines. The field text will auto return at the end and go to
the next existing line. The contract (report) has to have the text and
all the lines in the case that I leave it blank and do sometimes.

Report (lines are there already)

Please list inclusions and exclusions
______________________________________
___________________________________________________________________


This is the control box that is transparent and sits on top of the above
in the report and doesnt start until after the word exclusions
I have already made this work by hand. I just typed in the 100 spaces on
the form then wrote some sample text

(space space space etc.---------------)[This is text from the field that
will auto return
Now I am still sitting on top of the lines on the second line in the
report.

The spaces could cover the Please text? if so it is no problem to write
something or set something in the form field so the typist starts at 100
spaces. Its a memo field that scrolls so the user will never know he is
actually starting at the end of a 100 spaces

Okay, thanks for clarifying. So you are trying to give an underlined
effect to the text the report is reading from a field.

You can do that in Access 2007 quite easily, by using a rich text box on
the report. The control source would be:
="Please list inclusions and exclusions <u>" & [SomeField] & "</u>"

It should be possible to place the text box with the lines behind the one
that contains the text if you set the background style to transparent.

Post back if it still isn't working.

I wasnt clear enough or I dont understand your approach which is likely:

Your suggestion works perfectly to put the text in the report except
that text is already there. I want to take the text that was entered
into the form and stored in the field, to the report which already has
"Please etc.__________" on the report. I want to place the control box
which displays that info over the Please etc. I cant put anything in
the control box on the control that fits into the report because it is
filled with the field info.



Try a text box with Control Source of:
= "Please list inclusions and exclusions " & String(200, "_")

Adjust the box so it's 3 lines high (or whatever you need.)
Any extra characters just get ignored.

Any yes, fredg has contributed to many people's successes.

I am still working on populating a contract from form to report.

There are several lines in the contract that cant be changed that look
like this

Please list inclusions and exclusions
______________________________________
___________________________________________________________________
____________________________________________________________________


I place a control box over the lines and make it transparent but
obviously the text either covers the "Please etc."
Or if i size it to fit the end of the line the second line margin
starts too far to the right.

btw: fredg
I want to express my appreciation for your prompt replies. Everything
is working great due to your efforts. Its really nice to see someone
so helpful
If you ever need info on real estate or private investigation I am
your contact.

 

[Dan Goble]

=Space(100) & [SomeField]

It worked absolutely perfectly Allen.

The text moved over to the place it should start in the report and sat right
on top of the lines and returned to the next line. And I wont have to do
anything to the form that feeds the report info in the form of fields to
fill in the blanks.

Thanks for hanging in there. You are a patient man.
Dan

Sorry, Dan, I'm not sure I understand the problem. Perhaps someone else
can jump in and help us.

I'm confused by your comment at the end. Since you posted to the Reports
group, I assume we are talking about a printout here, and you just want
the text in the text box to print out at the right place. The typist can't
type into the report though -- well, not unless you are talking about the
new report view in Access 2007 perhaps?

I can follow the idea of a text box on a *report* that is bound to an
expression such as:
=Space(100) & [SomeField]

Of course, if the user has been entering that record in the form, the
record in the form will need to be saved before it will turn up on the
report correctly.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"Please list inclusions and exclusions" and the lines that I previously
showed are already displayed on the report. Dont need any underlines or
the Please text. I just need the field that displays to have 100 spaces
before the field starts to display so I can pass up the "Please text in
the report and then I will move the transparent field up or down to fit
the existing lines. The field text will auto return at the end and go to
the next existing line. The contract (report) has to have the text and
all the lines in the case that I leave it blank and do sometimes.

Report (lines are there already)

Please list inclusions and exclusions
______________________________________
___________________________________________________________________


This is the control box that is transparent and sits on top of the above
in the report and doesnt start until after the word exclusions
I have already made this work by hand. I just typed in the 100 spaces on
the form then wrote some sample text

(space space space etc.---------------)[This is text from the field that
will auto return
Now I am still sitting on top of the lines on the second line in the
report.

The spaces could cover the Please text? if so it is no problem to write
something or set something in the form field so the typist starts at 100
spaces. Its a memo field that scrolls so the user will never know he is
actually starting at the end of a 100 spaces

Okay, thanks for clarifying. So you are trying to give an underlined
effect to the text the report is reading from a field.

You can do that in Access 2007 quite easily, by using a rich text box on
the report. The control source would be:
="Please list inclusions and exclusions <u>" & [SomeField] & "</u>"

It should be possible to place the text box with the lines behind the
one that contains the text if you set the background style to
transparent.

Post back if it still isn't working.

I wasnt clear enough or I dont understand your approach which is likely:

Your suggestion works perfectly to put the text in the report except
that text is already there. I want to take the text that was entered
into the form and stored in the field, to the report which already has
"Please etc.__________" on the report. I want to place the control
box which displays that info over the Please etc. I cant put anything
in the control box on the control that fits into the report because it
is filled with the field info.



Try a text box with Control Source of:
= "Please list inclusions and exclusions " & String(200, "_")

Adjust the box so it's 3 lines high (or whatever you need.)
Any extra characters just get ignored.

Any yes, fredg has contributed to many people's successes.

I am still working on populating a contract from form to report.

There are several lines in the contract that cant be changed that
look like this

Please list inclusions and exclusions
______________________________________
___________________________________________________________________
____________________________________________________________________


I place a control box over the lines and make it transparent but
obviously the text either covers the "Please etc."
Or if i size it to fit the end of the line the second line margin
starts too far to the right.

btw: fredg
I want to express my appreciation for your prompt replies.
Everything is working great due to your efforts. Its really nice to
see someone so helpful
If you ever need info on real estate or private investigation I am
your contact.