Okay I've got a two problems here. The first is a problem with a query in my form, I have a field that can be 4000 characters long displayed in a list with relitivly small text boxes. If the content is over a 100 or so characters the field appears as gibberish, writing on top of itself. I tried to correct this by using a Left or Mid in the query to limit it to 100 characters (they will expand in another screen this is just to establish a parent component) which worked well at first until I moved the application to our test machines where I found that my fix will not work if the machine does not have microsoft development tools installed. I either need a way to limit the content of the field to 100 characters or force the field to display correctly dispite a 4000 character content.
The second problem is much simpler to explain, In another section of the program I am taking user input and there are certain fields that are not required, but when I try to insert the record into the table (I use docmd.runsql after I build my statement so that I can also write this to a logging file) I recive a notification that access set 1 feild(s) null due to ...... ok cancel. If I press ok it will continue and insert the record, but I really need to get rid of the error message, the clients will think the program blew up on them. The only way I could think of to do this was building my statement in nested if queries and due to the number of field and possible combinations I estimated approx 100 lines of code that I don't want to do.... Thanx for any sugguestions
The second problem is much simpler to explain, In another section of the program I am taking user input and there are certain fields that are not required, but when I try to insert the record into the table (I use docmd.runsql after I build my statement so that I can also write this to a logging file) I recive a notification that access set 1 feild(s) null due to ...... ok cancel. If I press ok it will continue and insert the record, but I really need to get rid of the error message, the clients will think the program blew up on them. The only way I could think of to do this was building my statement in nested if queries and due to the number of field and possible combinations I estimated approx 100 lines of code that I don't want to do.... Thanx for any sugguestions
