Great!! Glad to help
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 9:20 AM Subject: [RBG7-L] - Re: Property DB List Box > 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. > > > > > > > > > > > > > > > > > > > >
