Sharon,
I think it was Bill Downall who has used a union command in the choose to
add in a header line to the menu items. Something like this:
choose ... from ... #values for select ('Heading1...Heading2... Heading3') +
union (col1 & col2 & col3) +
where ...+
from .. +
order by .. +
at ... +
title 'Chose your item:' +
lines 10 formatted
Don't go on my syntax - I'm writing from memory - but with luck you'll get
the idea.
Regards Alastair.
----- Original Message -----
From: "Richard Starkey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 8:26 PM
Subject: RE: Choose Part 2 - Text Formatting
> Sharon,
>
> Do you mean the Title 'text' of the choose command? If so, I do not think
> the (LJS()) function will work on the title.
>
> You might want to manually add spaces between the titles until they line
up
> with the choose columns.
>
> Rich
>
>
> --Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Sharon Lima
> Sent: Tuesday, April 30, 2002 2:37 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Choose Part 2 - Text Formatting
>
>
> Thanks Rich, that did it as far as the columns being in a straight line.
> Now how do I get the header to line up with the columns?
> That is, how do I get the T I T L E line to left justify?
> Sharon
>
> ----- Original Message -----
> From: "Richard Starkey" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 30, 2002 2:02 PM
> Subject: RE: Choose Part 2 - Text Formatting
>
>
> > Sharon,
> >
> > Add "FORMATTED" as the last item in your choose command.
> >
> > Rich Starkey
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Sharon Lima
> > Sent: Tuesday, April 30, 2002 12:58 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Choose Part 2 - Text Formatting
> >
> >
> > I have been following this dialog to see if I can get the columns to
line
> up
> > on the menu box. Below is what I have tried but the second and third
> > columns still do not line up straight. For example, on a given line, if
> the
> > first column is only 4 letters, then the second column is further to the
> > left than it is on a line where the first column is 10 letters.
> >
> > CHOOSE vtEmpID FROM #VALUES FOR +
> > (LJS(FORMAT(ELNAME,'%%%%%%%%%%%%%%%%%%%%'),20) +
> > & LJS(FORMAT(EFNAME,'%%%%%%%%%%%%%%%'),15) +
> > & LJS(FORMAT(SPOUSE,'%%%%%%%%%%%'),11)), EMP# +
> > FROM Employee +
> > ORDER BY ELNAME, EFNAME +
> > AT CENTER, CENTER +
> > TITLE 'LastName FirstName Spouse' +
> > LINES 8
> >
> >
> > If there is something I missed please give example.
> > I did not understand the directions to add FORMATTED to the CHOOSE
> command.
> >
> > Thanks,
> > Sharon
> >
> >
> > ----- Original Message -----
> > From: <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 30, 2002 10:32 AM
> > Subject: Re: Choose Part 2 - Text Formatting
> >
> >
> > > In a message dated 4/30/2002 9:16:34 AM Eastern Daylight Time,
> > > [EMAIL PROTECTED] writes:
> > >
> > > << Have you tried putting FORMATTED at the end of your choose? >>
> > > RJ,
> > > I just tried it, and the choose box is wider, but the columns still
vary
> > by
> > > the width of the first column.
> > > Thanks for the idea
> > > Damon
> > >
> > > Damon D. Kaufman
> > > President
> > > Stalder Spring Works, Inc
> > > ISO-9002 / QS-9000 Certified
> > > 2345 S. Yellow Springs St.
> > > Springfield, Ohio 45506
> > > Voice 937-322-6120
> > > Fax 937-322-2126
> > > email: [EMAIL PROTECTED]
> > > ================================================
> > > TO SEE MESSAGE POSTING GUIDELINES:
> > > Send a plain text email to [EMAIL PROTECTED]
> > > In the message body, put just two words: INTRO rbase-l
> > > ================================================
> > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > > In the message body, put just two words: UNSUBSCRIBE rbase-l
> > > ================================================
> > > TO SEARCH ARCHIVES:
> > > http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >
> >
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: INTRO rbase-l
> > ================================================
> > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: UNSUBSCRIBE rbase-l
> > ================================================
> > TO SEARCH ARCHIVES:
> > http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >
> >
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: INTRO rbase-l
> > ================================================
> > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: UNSUBSCRIBE rbase-l
> > ================================================
> > TO SEARCH ARCHIVES:
> > http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >
>
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
