It looks okay to me. You could remove one of the nz() functions, then the other, to test if both work separately and at the same time be less than 255 characters. If so, you'll be in a pickle and would probably have to rename the query or the textboxes to be shorter names. Or use VBA instead of a macro.