Recent content by oldmags

I am using Access 2010. I appreciate your help, thank you

I tired that but it didn't work, it produced the usual #Name? When I did it the way from another tip, You can do this using the Format Property of the Control: To show in Red with Negative Sign, i.e.-5 do 0;[Red] It did work, but only showed in the field when I was in that field, when I went...

Thank you, conditional format did work, but the result only shows when I click on the field. If I click on any other field, the answer does not show. I have this Expression in there =Sum(([Payment Received]+[Sales from Repositary]+[Special Collection Income])-([Cost of Van hire]+[Stipend for...

To YPMA! Sorry, I cannot get the hang of trying to reply!! I see a quick reply button but nothing happens I have an Expression in that field which is =Sum(([Payment Received]+[Sales from Repositary]+[Special Collection Income])-([Cost of Van hire]+[Stipend for Priest]+[Travel Exp...

Thank you, that did work, but the result only shows when I click on the field. If I click on any other field, the answer does not show. I have this Expression in there =Sum(([Payment Received]+[Sales from Repositary]+[Special Collection Income])-([Cost of Van hire]+[Stipend for Priest]+[Travel...

Hi everyone, I would like to have my currency field in a form to show red when negative, I can do it in Excel but cannot figure it out in Access. Can anyone help please? Thank you, Oldmags

Thank you! Fabulous, I am in Office 2010 but following your guide I got rid of it, I am very grateful for your quick response, great to learn something new too! Regards oldmags

I hope someone can help me with this problem, I designed a standalone database preiously and to save time used it as a template for a new one. The table is OK, I renamed all fields, deleted all queries etc, on getting into the form, I renamed all fields from old, or created new ones, changed the...

I am not a programmer, but someone who has used Access for many years designing little stand-alone Db for work use. I enjoy using them to run query's finding out either finance or order staus etc. I have joined this forum as I am stuck on a new database I am designing for a local Church. I hope...