Paul That part is already done - the full value I want IS in a table;
Jones, Allen .. . . . . . . . (781)344-2222 But because of fonts, the actual size on the report of all records is still NOT the same and it must be right and left justified for it to line up. David "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Paul [mailto:[email protected]] Sent: Wednesday, December 9, 2009 11:11 PM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - RE: Justifying both sides of a report field First create a temp table and place your Anderson, John . . . . . . . . . .. . . .(781)344-1222 in the rows.Using a declare cursor command. In the dc I would use cval and use thesget the first (, then proceed with sput etc. to fill the vacant spaceswith your . Replace the past value and .......... done.Using several combination will complete the job.Paul "my.02"From: [email protected] [mailto:[email protected]] On Behalf Of DavidBlockerSent: Wednesday, December 09, 2009 9:39 PMTo: RBASE-L Mailing ListSubject: [RBASE-L] - Justifying both sides of a report field I?m creating a report which lists Name and phone number on one line,separated by a line of dots: Anderson, John . . . . . . . . . . . . . .(781)344-1222Bones, Ellen . . . . . . . . . . . . . . . . (617)211-1222 The line should be JUSTIFIED ? i.e., left side and right sides line up. I?ve created an expression which fills the space between the name and numberwith dots, but R:Base won?t let me justify the field on the report, even ifit's all combined into a column in a table. I?ve tried using DB Text andRich Text, but the justify option on the top of the screen is grayed out. Without using the justify, the right sides don?t line up To complicate matters, the phone number might be null AND below the name andnumber, the client wants to print the email address, which also might benull. Blank lines should be suppressed: Anderson, John . . . . . . . . . . . . . .(781)[email protected] Bones, Ellen . . . . . . . . . . . . . . . . (617)211-1222Carter, Andrew. . . . . . . . . . . . . . .(617)[email protected] Because of the potential blank lines, the best way to create the report isusing rich text fields, with mailmerge items in each one, and each rich textinside a region. But? I can?t justify a rich text field. Ideas? David"David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" --- RBASE-L=======================3D======================D=TO POST A MESSAGE TO ALL MEMBERS:Send a plain text email to [email protected](Don't use any of these words as your Subject:INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)=======================3D======================D=TO SEE MESSAGE POSTING GUIDELINES:Send a plain text email to [email protected] the message SUBJECT, put just one word: INTRO=======================3D======================D=TO UNSUBSCRIBE: Send a plain text email to [email protected] the message SUBJECT, put just one word: UNSUBSCRIBE=======================3D======================D=TO SEARCH ARCHIVES:Send a plain text email to [email protected] the message SUBJECT, put just one word: SEARCH-n(where n is the number of days). In the message body, place any text to search for.=======================3D======================D=
