By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 992 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

passing a string or building a string for testing

P: n/a
I know this is a stupid question but I can't find the answer.
Please tell me where to find reference to this so I can print it out
and staple it to my head..

dim I as integer
dim missedstr as string

For i = 1 To 17
'If IsNull("question" & i & ".Value") Then
missedstr = missedstr & " question " & i
Next

I know that this does not work..it is saying that the string is null which it
never is.

I have added this to a string and passed it to the check and it says the string
is not null.

HOW do I have it check the value in the question to see if it is null..

I must be searching on the wrong syntax because I can't find it anywhere
thanks big time for a pointer to the answer
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"sparks" <sp****@anywhere.com> wrote in message
news:jm********************************@4ax.com...
I know this is a stupid question but I can't find the answer.
Please tell me where to find reference to this so I can print it out
and staple it to my head..

dim I as integer
dim missedstr as string

For i = 1 To 17
'If IsNull("question" & i & ".Value") Then
missedstr = missedstr & " question " & i
Next
I know that this does not work..it is saying that the string is null which
it
never is.
I have added this to a string and passed it to the check and it says the
string
is not null.
HOW do I have it check the value in the question to see if it is null..
I must be searching on the wrong syntax because I can't find it anywhere


When you write:
If IsNull("question" & i & ".Value") Then

I suppose "question" & i stays for a field name in your form.
If so you must write:

If IsNull(Me("question" & i)) Then

This is a rare case requiring Me, which is normally
a redundant word.

Bruno

Nov 13 '05 #2

P: n/a
Thank you VERY much for pointing that out to me.
On Fri, 15 Apr 2005 16:05:01 GMT, "Bruno Campanini" <br*************@tin.it>
wrote:
"sparks" <sp****@anywhere.com> wrote in message
news:jm********************************@4ax.com.. .
I know this is a stupid question but I can't find the answer.
Please tell me where to find reference to this so I can print it out
and staple it to my head..

dim I as integer
dim missedstr as string

For i = 1 To 17
'If IsNull("question" & i & ".Value") Then
missedstr = missedstr & " question " & i
Next
I know that this does not work..it is saying that the string is null which
it
never is.
I have added this to a string and passed it to the check and it says the
string
is not null.
HOW do I have it check the value in the question to see if it is null..
I must be searching on the wrong syntax because I can't find it anywhere


When you write:
If IsNull("question" & i & ".Value") Then

I suppose "question" & i stays for a field name in your form.
If so you must write:

If IsNull(Me("question" & i)) Then

This is a rare case requiring Me, which is normally
a redundant word.

Bruno


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.