[AccessD] Creating a Bulleted List

Charlotte Foust cfoust at infostatsystems.com
Wed Oct 29 10:38:53 CST 2003


You probably had the textbox positioned slightly above the bullet.  Try
top aligning them.

Charlotte Foust

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Wednesday, October 29, 2003 7:51 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Creating a Bulleted List


Bob:

That's exactly what I tried but the bullet always got repositioned below
the text line after the text line grew.  I used the 'developer stupid'
approach to solve it.  Realizing that there would always be a line of
text I made the text line and the bullet the same height and turned the
bullet on and off depending on the bullet flag of the detail line.  So
avoided the whole problem instead of solving it.

But I'm still a bit curious as to what you did different than me that
made the bullet come out aligned top with the text line.

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 4:43 AM
Subject: Re: [AccessD] Creating a Bulleted List


> Bob
>
> ...nice approach ...but won't this always offset the text whether you 
> show the bullet or not?
>
> William Hindman
> <http://www.freestateproject.org> - Do you want liberty in your 
> lifetime?
>
>
> ----- Original Message -----
> From: "Bob Gajewski" <rbgajewski at adelphia.net>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, October 28, 2003 7:31 AM
> Subject: RE: [AccessD] Creating a Bulleted List
>
>
> > 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
> >
> >
> > _______________________________________________
> > 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


More information about the AccessD mailing list