Character limit

  • Thread starter Thread starter dst393 via AccessMonster.com
  • Start date Start date
D

dst393 via AccessMonster.com

I have a string, which is long. It is an update statement. When I display
the results in the message box, my statement is cut off at the end. What I
did was put the where part in a different string variable and concatenate the
two strings, but that did work. Does anyone have any ideas?
 
I am not sure why you would want to display a SQL Update statment in a
message box... I do know that sometimes very complex SQL can be lengthy and
you can run out of line continuations, which you would then simply end the
string and then start it up again with itself + additional SQL as in ...
strSql = strSql & "WHERE this = that" if you are just wanting to look at it
in its entirety you can do several things... use the old

debug.print strSQL
or
simply stop the code and then in the immediate window type ?strSQL
or
create a query and set its SQL to your strSQL

This may not be anything like what you are looking for in an answer and then
I do apologize as I am not sure I actualy understand the question or what it
is that you are seeking to do... Please forgive and maybe elaborate on the
problem? Thanks
 
Since the limit is 1023 characters for a msgbox call, you either have to
create a form and pass the information to the form and its control
or break the statement into two successive msgbox calls
or Debug.print the statement and open the immediate window in vba
or ...
 
Thanks, I got it working.

John said:
Since the limit is 1023 characters for a msgbox call, you either have to
create a form and pass the information to the form and its control
or break the statement into two successive msgbox calls
or Debug.print the statement and open the immediate window in vba
or ...
The maximum number of characters for the prompt argument of a message box
is
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
 
Back
Top