Using data validation, I am limiting the number of characters which can be entered into various columns. However, I have four columns, each of which need to be able to take 400 characters, but be limited to a total of 400 characters for the four columns. (They are being concatenated and then loaded into a VARCHAR(400) field in SQL Server). Is there any way to do this without using a macro? I have tried adding another column with the sum of the characters for the four columns and then applying the data validation to that column, but it doesn't work in a satisfactory manner. Can this be done without programming?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.