Cstr null error

W3Schools is Powered by W3. Any valid expression If expression is: Boolean - then the CStr function will return a string containing true or false. Date - then the CStr function will return a string that contains a date in the short-date format. Null - then a run-time error will occur. The problem sounds like one of the columns allows null values or they both do. While cstr function will convert the number to a string, the function will error out if the column has a null value cstr function does not work on null columns.

So, you have to use a expression that converts the empty null to some string. This type of join will run quite slow. I would perhaps ask the server guy if a view of the joined tables can be created for you.

You would then link to that view and it would eliminate the need for the ctstr in those joins, and in fact you would not need to create the join either. I suggest this since your current setup will not perform well since those types of joins can't be optimized by access. Value, "DataSet1". If above two desont work. Sign in. United States English. Ask a question. Quick access. Search related threads.

Remove From My Forums. Answered by:. Archived Forums. Erik A Erik A Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back