Thank you David. It works. Deb Roepken cmri 631-587-1495
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David M. Blocker Sent: Friday, November 19, 2004 9:07 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Property DB List Box Deb Yes. The RJS function applies to text only. You must also use the CTXT function to convert to text. For example, if the column is Amount INTEGER, this expression converts it to text, which by default is LEFT justfied: (CTXT(Amount)) To Right justify within 15 characters you: (RJS( (CTXT(Amount)), 15)) Notice how the parens are balanced: two open and two close for each function David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Deb Roepken" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, November 19, 2004 8:50 AM Subject: [RBG7-L] - Re: Property DB List Box > Thank you David, I see his example and I'll give it a try. The column im > trying to RJS is an integer. Would this make a difference? > > Deb Roepken > cmri > 631-587-1495 > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David M. > Blocker > Sent: Wednesday, November 17, 2004 3:55 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Property DB List Box > > > Debra > > Have you looked at Mike's sample? It's a very simple model and it took my 5 > minutes to copy the idea and set it up on a form. And it works fast. > > David > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: "Debra A. Roepken" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, November 16, 2004 10:23 PM > Subject: [RBG7-L] - Re: Property DB List Box > > > > David, I thought of that too. However to modify a view and table to > simply > > right align the text is timely. I've tried sql(rjs) in the listbox lookup > > code, as well as in the create view function. The property alignment > object > > control explains it would right align the 'text in the control'. > > > > Deb Roepken > > CMR, Inc. > > 1468 13th Street > > West Babylon, NY 11704 > > 631-587-1495 > > 516-662-4767 > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David M. > > Blocker > > Sent: Sunday, November 14, 2004 2:02 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - Re: Property DB List Box > > > > > > Deb > > > > That's not what alignment right does. It aligns the control with the > right > > edge of the parent, either the form or a panel or tab, etc. where the > > control is located > > > > To right justify the text in the list box, I believe your best bet is to > use > > a Variable user Defined List Box that Mike Byerley helped get included in > > the product. I just was looking at it yesterday. It's available on the > 2004 > > spring conference CD under mike's directory, form Rolodex as the sample. > > > > David Blocker > > [EMAIL PROTECTED] > > 781-784-1919 > > Fax: 781-784-1860 > > Cell: 339-206-0261 > > ----- Original Message ----- > > From: "Deb Roepken" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Sunday, November 14, 2004 9:08 AM > > Subject: [RBG7-L] - Re: Property DB List Box > > > > > > > Thank you Razzak, I've gotten some Property's to work, after placing an > > > RB_FORM_... first, however, Alignment 'RIGHT' is not working to right > > > justify the text inside the control. I'll keep trying. > > > > > > Deb Roepken > > > cmri > > > 631-587-1495 > > > > > > > > > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak > > > Memon > > > Sent: Sunday, November 14, 2004 7:50 AM > > > To: RBG7-L Mailing List > > > Subject: [RBG7-L] - Re: Property DB List Box > > > > > > > > > > > > At 12:09 AM 11/14/2004 -0500, Deb Roepken wrote: > > > > > > >I've been trying to right justify my DB List Boxes > > > >with lookups to views. I've placed the Property > > > ><CompID> Alignment 'right' in before start properties > > > >in form; in before start in app; can't find a place > > > >to put it in the object. I've even experimented > > > >with Property color change for DB Grid with null > > > >results. Any suggestions! > > > > > > Deb, > > > > > > If you would like to change the PROPERTY of any > > > control(s) placed on a form, you'll need use the > > > PROPERTY command in "On After Start EEP". > > > > > > Example: > > > > > > Form Designer | Form Properties | Miscellaneous > > > | On After Start EEP > > > > > > PROPERTY <Component ID> ALIGNMENT 'RIGHT' > > > RETURN > > > > > > Have fun! > > > > > > Very Best R:egards, > > > > > > Razzak. > > > > > > > > > > > >
