Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Anyway to link the size of fields to a field that 'Can Grow' ?

Status
Not open for further replies.

MrSnid

Technical User
Apr 4, 2008
6
US
I have been asked to 'fix' a report which allows a 'notes' field to expand with the length of the note. The 'Notes' field expands and the rest of the line does not which "could cause some confusion for those reading the report".

Thanks
Leon
 
How are ya MrSnid . . .

For the field, have a look at the Can Grow/Can Shrink properties . . .

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886
 
Aceman1

I am doin pretty fair today (thanks !) feel like I need to say 'long time listner, first time posting'...

The 'notes' field is expanding the way it should, it is the other fields on the line that do not expand.

Is there a way to have the entire line grow in proportion to the one field that needs to expand ?

I have tried 'Can Grow: Yes' on the other fields, but that does not seem to work.

Thanks again

 
I've come up with another way to ask my question...

Is there a way to reference another Field's property in the field property of another field.

For Instance, I would like Field194 to have the same dimensions of Field294 where Field294 Can Grow=Yes.

 
MrSnid . . .

In the [blue]OnPrint[/blue] event of the detail section, try:
Code:
[blue]   [TextboxName1].Height = [TextboxName2].Height[/blue]

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886
 
I found this posted on anther board...

Don't use borders. Instead, draw the boxes using the Line
method in the Print event. For example, add a line of
code for each text box:

Me.Line (text1.Left,0) - Step(text1.Width,Me.Height),,B

Which tells me there is a way to do it, just not one I've heard of or know how to do...anyone have familiarity with this particular bit of code (and has the time/patience to explain how its used to a novice with code ?)

Thanks again,
Mr Snid
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top