Re: [libreoffice-users] LO Base Colour settings in Form design.

On 11/23/2012 10:24 AM, Ian Whitfield wrote:
> Hi All
>
> I have a Membership Database running on MySQL 5.1 with an LO Base 
> Front end Ver 3.6.2.2. All running on PCLOS 2012.
> My Members fall into two or three different Categories and I would 
> like to be able to show this on screen.
>
> SO - Is it possible to add in a statement to the Form design so that 
> the background colour of the Form will change depending on the value 
> set in a field called 'Cat'?
>
> Something like....
> IF 'Cat'="abc" THEN Bgd Colour = "<colour string1>" OR
> IF 'Cat'="cde" THEN Bgd Colour = "<colour string2>"
>
> Thanks for any help!!
>
> IanW
> Pretoria RSA
     To do this you will have to create a macro. Use the Events tab of 
the Control tool to assign the macro to 'Cat'. I don't know how well you 
understand macros nor how to create them.
     I don't have any experience in using macros, so I can not make any 
suggestions as to the required macro's content. From what little I have 
seen, it may contain some lengthy lines of code. Others with macro 
experience may be able to point you in the right direction.

--Dan

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted