Here's a suggestion, but it would be a lot of work. For each box, locate 2 controls, one with the bigger font and one with the smaller font, and give each control a component ID. On the "on before generate" eep, test the length of the data to be printed and make one of the 2 controls visible. You could also have just one control and have the eep change the font size (I think), but I'm not sure how that would affect your 3rd row
Karen -----Original Message----- From: Chaya Goldberg <[email protected]> To: [email protected] <[email protected]> Sent: Thu, May 9, 2019 4:52 pm Subject: RE: [RBASE-L] - calendar grid <!-- #yiv1335607397 _filtered #yiv1335607397 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv1335607397 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv1335607397 #yiv1335607397 p.yiv1335607397MsoNormal, #yiv1335607397 li.yiv1335607397MsoNormal, #yiv1335607397 div.yiv1335607397MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", serif;} #yiv1335607397 a:link, #yiv1335607397 span.yiv1335607397MsoHyperlink {color:blue;text-decoration:underline;} #yiv1335607397 a:visited, #yiv1335607397 span.yiv1335607397MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv1335607397 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", serif;} #yiv1335607397 p.yiv1335607397MsoListParagraph, #yiv1335607397 li.yiv1335607397MsoListParagraph, #yiv1335607397 div.yiv1335607397MsoListParagraph {margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", serif;} #yiv1335607397 span.yiv1335607397EmailStyle18 {font-family:"Calibri", sans-serif;color:#1F497D;} #yiv1335607397 span.yiv1335607397EmailStyle19 {font-family:"Calibri", sans-serif;color:windowtext;} #yiv1335607397 .yiv1335607397MsoChpDefault {font-size:10.0pt;} _filtered #yiv1335607397 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv1335607397 div.yiv1335607397WordSection1 {} -->Hi Everyone, I have a report with a calendar-like grid, where each day’s attendance gets printed in a box designated for it. The attendance will generally be between 2 and 16 characters long and fit onto 1-3 lines. Each day’s attendance is saved as type varchar(25). The way I have it currently set up, the print will be uniformly small, so that all possible characters will always fit into the box. I’d like to modify it so that if there are only 2 characters, then they will show up in a larger size and take up the entire box. Is this possible? And how do I do this? Thanks in advance, Chaya -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/951D27977F7EA4478392D6E4EE398D8B01E3E4A2CC%40omniEX08.OmniRehab.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/336817656.3113542.1557491325909%40mail.yahoo.com. For more options, visit https://groups.google.com/d/optout.
