Search results

If you have a text box of a set size how would I code an automatic font size reduction if the text string in it was too long. (It has to shrink or it obscures the box below it). ie if it is over so many characters set size 14, if over even more set size 12 etc. many thanks. This is on a form...

Hi all, I have the following working line of code (Running once a button is pressed in a form) DoCmd.ApplyFilter , "[Site Location] = 'Site A'" However I now need to modify this to search for the text in two fields, both Site Location and Site Location2, to return results if it is found...