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. Alex -- For unsubscribe instructions e-mail to: users+h...@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