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: [email protected]
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
