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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can Grow like MS Access 1

Status
Not open for further replies.

SteveCulshaw

Programmer
Oct 13, 2000
48
GB
Is there someway to emulate the way Access handles fields with the "Can Grow" property set to Yes?
i.e. in an Access report, if I have two fields, one below the other, and the first field grows, the second one is moved down. But in my Crystal report, the first field overwrites the second one [sad]
Apologies if this is something basic, but I've got to do a quick comparison between the two reporting techniques, and whilst I know Access, I don't know Crystal Cheers,
Steve C.
 
1. Highlight the field that you want to set "can grow" property
2. Go to format -> format field...
3. In the Common Tab, put the check mark beside the Can Grow
 
Sorry I'm not after how to set the Can Grow property, what I'm after is someway to avoid fields overwriting each other when they grow.
In Access this is done automatically, but I can't find anything similar in Crystal
Is there some formula that can check the size of current field and move down fields below it (seems a bit messy) Cheers,
Steve C.
 
The best way to do this is to split your section up into an a and b. Insert the first Can Grow field in a, and the remaining field in b.

The field in b won't be able to commence printing until the previous section has completed.

Naith
 
Thanks Naith, that works a treat [thumbsup]
- the multiple Detail sections isn't something that can be done in Access
- nice feature though !! Cheers,
Steve C.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top