Bob Gajewski
rbgajewski at adelphia.net
Tue Oct 28 06:31:30 CST 2003
William *************************************************** Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsNull([txtTextBox]) or [txtTextBox] = "" Then txtBullet = Null txtBullet.Visible = False Else txtBullet = Chr(62) ' Just a sample using ">" txtBullet.Visible = True End If End Sub *************************************************** Be sure to set both txtBullet and txtTextBox to CanGrow=Yes and CanShrink=Yes. Change the ASCII code to whatever you want actually displayed. Place the two text boxes on the same line on the report: [_] [_____________________________] I use this coding in some of my reports, and it works fine. Regards, Bob Gajewski -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of William Hindman Sent: Tuesday, October 28, 2003 02:36 To: Access Developers discussion and problem solving 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