Recent content by CrustyB

No I get your point entirely; please don't think I'm being dismissive of what you say, it's definitely taken into account. Thanks again both for your help!

Hi and many thanks for your help. Changing the datatype to number in "TESTS" along with clng now has it working correctly. The way this was being used previously entailed the values input into TESTS sometimes being alphanumerical; I'd been focused on the datatype for ITEMS and didn't think of...

I've attached a copy of the database with all the tables wiped. There's one record left for testing purposes (returns no 4216). On the frontpage, select 4216 in the "SAV" combo box. Select the "TEST" tab. The field I've been attempting to do this on is "Inlet Pressure" using "TESTINMIN" and...

I'm afraid I can't post the database as it contains customer data and data sensitive to the business. I can see if I can create a sanitised version to show you, but I won't be able to do so immediately. I do appreciate your offer to look at it though! The forms are all singe view, I believe.

Hi @MajP many thanks for your help. Unfortunately, using clng doesn't seem to have affected the behaviour. The datatype in table "ITEMS" for TESTINMIN and TESTINMAX are set as Number, Double. Is there another way to achieve the result I'm after without using conditional formatting?

I'm currently working on a database for product warranty returns, with a test results input form which will colour a field using conditional formatting based on values a user inputs in reference to max and min values from a table. The basic setup of the parts relative to this question is: *...