William Hindman
wdhindman at bellsouth.net
Tue Oct 28 09:03:53 CST 2003
...works for you, works for me ...especially the egg ...wear it all the time :) William Hindman <http://www.freestateproject.org> - Do you want liberty in your lifetime? ----- Original Message ----- From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Tuesday, October 28, 2003 9:57 AM Subject: Re: [AccessD] Creating a Bulleted List - Solved > OK. So I solved it the really stupid way. It occurred to me that the text > box does not have to start at zero height because there will always be at > least one line. So I made it the height of one line with Can Grow - True > and the label with the bullet next to it (set Visible/Invisible, depending > on the record) and it works just fine. > > Next up, he wants the option for a numbered list as well (sigh). > > With egg on face, I remain, > > Rocky Smolin > Beach Access Software > > ----- Original Message ----- > From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Tuesday, October 28, 2003 6:27 AM > Subject: Re: [AccessD] Creating a Bulleted List > > > > I think the catch here is that because the text box starts out with zero > > height and Can Grow is true, during the Print it's pushing the bullet down > > below the text box. They can't seem to end up on the same line. I tried > > putting the .Top of the bullet to the .Top of the text box in the OnPrint > > event but you can't set it there. > > > > But then I'm putting the bullet in a label with a zero height and setting > > the height to about 250 to make it visible when fldBullet is set to true. > > I'll try the image control and see what happens. > > > > Rocky > > > > ----- Original Message ----- > > From: "William Hindman" <wdhindman at bellsouth.net> > > To: "Access Developers discussion and problem solving" > > <accessd at databaseadvisors.com> > > Sent: Tuesday, October 28, 2003 5:33 AM > > Subject: Re: [AccessD] Creating a Bulleted List > > > > > > > Rocky > > > > > > ...this works for me in an AXP test mdb ...gives an indented text box > with > > a > > > bullet or an unindented text box without a bullet. > > > > > > ...in your report detail section, place an image control (imgImage0) > with > > a > > > bullet image embedded ...to the left of it place your textbox (txtText1) > > > where you want the indent to start. > > > > > > ...place this in your reports cbf detail DetailFormat > > > > > > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) > > > If Reports!Report1.Controls!imgImage0.Visible = False Then > > > Reports!Report1.Controls!txtText1.Move Left:=300 > > > Else > > > MsgBox "duh" > > > End If > > > End Sub > > > > > > ...adjust the move figure until it fits where you want it to reflect an > > > unindented text placement ...HTH :) > > > > > > William Hindman > > > <http://www.freestateproject.org> - Do you want liberty in your > lifetime? > > > > > > > > > ----- Original Message ----- > > > From: "William Hindman" <wdhindman at bellsouth.net> > > > To: "Access Developers discussion and problem solving" > > > <accessd at databaseadvisors.com> > > > Sent: Tuesday, October 28, 2003 2:35 AM > > > Subject: Re: [AccessD] Creating a Bulleted List > > > > > > > > > > ...picky, picky, picky :) > > > > ...how about using an image control for your bullet set for inline > with > > > your > > > > text box control? ...that should give you the effect you want ...HTH > :) > > > > > > > > William Hindman > > > > <http://www.freestateproject.org> - Do you want liberty in your > > lifetime? > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> > > > > To: "Access Developers discussion and problem solving" > > > > <accessd at databaseadvisors.com> > > > > Sent: Tuesday, October 28, 2003 12:44 AM > > > > Subject: Re: [AccessD] Creating a Bulleted List > > > > > > > > > > > > > Well, I'm trying to gild the lily by making it look like a hanging > > > > indent - > > > > > that is, a multi-line section of text would all be left adjusted > with > > > the > > > > > bullet to the left of the first line. Just pre-pending the bullet > to > > > the > > > > > text will work, I suppose, if I can't get it to look like a bulleted > > > list > > > > in > > > > > a Word doc. > > > > > > > > > > Rocky > > > > > > > > > > ----- Original Message ----- > > > > > From: "William Hindman" <wdhindman at bellsouth.net> > > > > > To: "Access Developers discussion and problem solving" > > > > > <accessd at databaseadvisors.com> > > > > > Sent: Monday, October 27, 2003 1:58 PM > > > > > Subject: Re: [AccessD] Creating a Bulleted List > > > > > > > > > > > > > > > > ...since the "bullet" is really just a text character, why not > > > > concatenate > > > > > > it with the text using an IIF function to turn it on or off? > > > > > > > > > > > > William Hindman > > > > > > <http://www.freestateproject.org> - Do you want liberty in your > > > > lifetime? > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > > From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> > > > > > > To: <AccessD at databaseadvisors.com> > > > > > > Sent: Monday, October 27, 2003 4:48 PM > > > > > > Subject: [AccessD] Creating a Bulleted List > > > > > > > > > > > > > > > > > > Dear List: > > > > > > > > > > > > I have a report which is a number of pieces of boilerplate text > > which > > > > are > > > > > > printed in the detail section of a report. There is also a > > > boilerplate > > > > > > header text. > > > > > > > > > > > > I set height of both to zero and the Can Grow property to true. > So > > > far, > > > > > so > > > > > > good. Formats nice. The user can set the Bold, Underline, and > > Italic > > > > > > properties for each piece of boilerplate. > > > > > > > > > > > > Now he wants the option to add bullets to the detail text. So I > > tried > > > > > > putting a bullet in a label, invisible, height zero, aligned top > > with > > > > the > > > > > > detail text. If the text bullet property is set to True then I > make > > > the > > > > > > label visible and set the height to 225 twips. All OK except that > > > > because > > > > > > the text can grow, instead of coming out like this: > > > > > > > > > > > > (bullet) Text One. > > > > > > (bullet) Text Two. > > > > > > > > > > > > It comes out like this: > > > > > > > > > > > > Text One. > > > > > > (bullet) > > > > > > Text Two. > > > > > > (bullet) > > > > > > > > > > > > Is there a way to make this work or a better way to create a > > bulleted > > > > list > > > > > > in a report where the detail field may or may not be bulleted? > > > > > > > > > > > > MTIA, > > > > > > > > > > > > Rocky Smolin > > > > > > Beach Access Software > > > > > > _______________________________________________ > > > > > > AccessD mailing list > > > > > > AccessD at databaseadvisors.com > > > > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > > > > Website: http://www.databaseadvisors.com > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > AccessD mailing list > > > > > > AccessD at databaseadvisors.com > > > > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > > > > Website: http://www.databaseadvisors.com > > > > > > > > > > > > > > > > _______________________________________________ > > > > > AccessD mailing list > > > > > AccessD at databaseadvisors.com > > > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > > > Website: http://www.databaseadvisors.com > > > > > > > > > > > > _______________________________________________ > > > > AccessD mailing list > > > > AccessD at databaseadvisors.com > > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > > Website: http://www.databaseadvisors.com > > > > > > > > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >