Hi Clarke,

One other comment, too.

The test "IsNull(Me.Text266)" is always going to return false if this is referring to a textbox on your form. VB never sets the default property (which is Text) for a textbox to Null. That's only necessary if the item you're testing for Null is coming from a database - I.E. testing a recordset column. So you can just do the one test on Trim(Me.Text266) = ""

BTW ... suggest that you indent your code - it will be easier to read. (That section wasn't indented as far as I could see).

- Max