Subject Re: Font Selection
From Ivan Benttini <>
Date Sat, 07 Sep 2019 18:56:03 -0400
Newsgroups dbase.getting-started

Mervyn Bick Wrote:

> On 2019-09-06 12:27 AM, Ivan Benttini wrote:
> >   I give up, all I want to do is change the last name of a field in any record in the table in use to BOLD when it is NOT but programmatically, can you show mw how?
> >
> Text in a field of a table can't be saved BOLD.  You will need to make
> the contents of specific fields bold when you display the data.
> Data can only be displayed in BOLD on a form in a text, entryfield or
> editor object or in a report in a text object. It can't be displayed in
> BOLD in a grid object.
> To display the text in bold in an entryfield you will heed to use the
> form query rowset's onNavigate event handler.
>     function rowset_onNavigate(type, nRows)
>        if this.fields['salary'].value >= 1000
>           this.parent.parent.entryfield2.fontbold := true
>        else
>            this.parent.parent.entryfield2.fontbold := false
>        endif
>        return
> Rowset event handlers don't understand form so you can't use
>     form.entryfield2.fontbold := true
> In the event handler
> this is the rowset
> this.parent is the query
> this.parent.parent is the form
> In a report you would use the the value displayed for the salary to set
> the fontbold property of the text object that displays the lastname.
> An example form and report are in the attached zip file.  The lastname
> is displayed BOLD where the salary is equal to or greater than 1000.
> Mervyn.
���bold_text.repXmo0̤_ؐICRKS6J!dp8xn^ڦ)kD|~G;sw=1L�11 'O?x(P�0
u0Db.Eghl̬B#R0FMxB`{̘o        _l9
L)X�f4S%bD0B|>Uw:E1#IV.QE2T4){8 F=v}r<nUYZD6YĵN9ǖ嘭B|"2MPU        ;q %-ߥ1&v/^2gE;mj94.v{ebnv,C/e!M2b\.<
ߥ-ڦYJS6tVF֥ )w7g\L#M&ta@hQT'^Kr*6{
9V؞k)<_[fc~Yg71RHlɸ$AAV~-X[&4YJYa"E(ϜW6 m!x_
r RLî/Q-ZvZXfU^T9sg        A{xHH2B*T$\Mm8c8N8d &\TyYIL~޲`_Wɒ:cymk\1i]C) QIVʺ,UrL:՟FV:sNrXqV[r,�KͼAjql,^+;g22wdISYHZLPK����=K&Of����
���bold_text.wfmUko0BH*%)ЇIR cjIbqg;/
> CjsεJPBd% v!b
-j<h6\.ԡ�K�Pqp/DAO4v-KJXs,Mi}м% EqYꑪ{yf̋&-16$*eD|.!]p%6%MQMcls y        Hjy        b1bKڬ+ǵtX        2uELbv0*bt;ɤ0Xc4}^dzk9F[a4Umb(z_JM/s<͘Fi=)aS]VSٰow5gяYPXk43b#<4:Я4j^covbz
v7`Jf=)S*ц> e]\L'߿Dd<6ELl]
kxb?[kw~şJ }mg/ZZiNf+_&?2>.st^/pG=qTTJ)J=o{2 5K߯xT|        B 5S-i*֟{՟(InA_PK?�����J&O+S��Y��
�$������� �������bold_text.rep
� �������jd Fd)!dPK?�����=K&Of����
�$������� ���~��bold_text.wfm
� �������<dPSd

Everything is now aok and running, they now ask if I could change onNavigator show the user last name in ALL CAPITALS letters.

   function form_onNavigate(type,nRow)
      // This function is only Applicable on the FORM object...
      local a
      a=form.entryfield3.value  //store value of EF3 in a variable
      ?"Last Name: ", a            // show it in the command window
      if FORM.entryfield3.fontbold = false   //change EF value
         FORM.entryfield3.fontbold = TRUE  // to BOLD
         //FORM.entryfield3.ColorNormal = "Blue" //that will block the last name
         //with color blue.

         // How can I turn the last name all cappitalise letters when
         // LAST NAME cames us LOW CASE or MIX of capital and lowcase?
         // Can I do that in dBasePLUS 2.8?  

         I could not find anything on the OL help or in my bible( Ken MAYER- the dBase Developing Application with dBasePlus).
Any help will be appreciated.
         ? form.entryfield3.value