Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Le 23/11/12 16:24, Ian Whitfield a écrit :

Hi Ian,

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'?

No, not directly. As others have said, you can only change colour
settings via macro. The colour of the form background is a property of
the document, which means that everytime you change that property, e.g.
because you have displayed a data entry that sets off the macro, then
you close the Form document, you will be asked if you want to save your
changes (logical, because you have in effect changed the document, even
if you have not changed the data bound from the database). This can lead
to confusion/irritation with the users of the form who think that they
either have to save something they possibly didn't change, or else the
next user when opening the form finds it in a strange colour (unless of
course your macro also fires on the "upon open" event to check whether
the data of the first field corresponds to a "doesn't meet the "colour
set" criteria of the other macro).

For questions like this, you really ought to be trawling the forums,
especially the OOo forums, where you are more likely to be able to find
someone who might have tried something similar, but unless you know
OOoBasic/LOBasic, then you will make slow progress.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.