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/
