Color in browse

[Richard Kreiss]

Laura,


cl was originally a 1 character filed that was either a Y or an N depending is any records existed in the call_file.  This was the last field in a browse lookup display.  If Y, then our security guard pressed <V> to list the names of individuals ho did not require a phone call to the resident being visited.  When I first programmed this function, if there were not records, a message box appeared with the message "All visitors must Be announced before proceeding".  After looking at the <Y> or <N> in the last column, I thought if the <N> were red the guard would immediately know call  was necessary.

I tried the following:

I reset the field cl(1,*) to cl(4,*) and tried 

Cl="\rN\r"
Cl="\b4N\a-"


When I tried cl(7,*)="\b:4N\a-"{"", the value displayed has a black background white lettering and is :4N.  The \b:4 value is per the help file with 5.8.  However, \b4N\a-"{"" works with the background in red and the N in white.  This should make it easier for the guard to know if the resident has any "do not call"  records on file.  I could program, if there are  records in the "do not call" file the ability to type in a name but that presents a whole set of issues I really don't want to get involved with.

Thanks for the help.

Richard Kreiss






> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Laura Brody via
> Filepro-list
> Sent: Friday, October 6, 2017 7:11 PM
> To: Richard Kreiss <rkreiss at gccconsulting.net>
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Color in browse
> 
> Could you post your code?
> 
> For this project, I would have another dummy field which is at least 7 characters
> long. Display that in the browse line. Put the value of cl into it, either with show
> codes around it (for the red color) or just the cl value.
> 
> Is that what you tried or something else?
> 
> Laura Brody
> 
> On Fri, Oct 6, 2017 at 5:03 PM, Richard Kreiss via Filepro-list < filepro-
> list at lists.celestial.com> wrote:
> 
> > I have a yes/no field cl(3,*) which is either a Y or N depending if
> > there is a record in a file names call_list.  A lookup is done using
> > the drop routine to set this value.
> >
> > I would like to have the N show up in red as that would avoid the user
> > having to press <V> to see if there are any names. (Y) indicates there
> > are and <N> no mane present.
> >
> > I have tried various combinations of display code without success.
> >
> > Any suggestion as to how I should be doing this?
> >
> > Windows 10
> > FilePro Version 5.8
> >
> > Richard Kreiss
> > -------------- next part -------------- A non-text attachment was
> > scrubbed...
> > Name: winmail.dat
> > Type: application/ms-tnef
> > Size: 14072 bytes
> > Desc: not available
> > URL: <http://mailman.celestial.com/pipermail/filepro-list/
> > attachments/20171006/f491d239/attachment.bin>
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20171006/cc0f979e/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 14836 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20171009/19b223bf/attachment.bin>