passing a string or building a string for testing

[sparks]

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("questio n" & 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

[Bruno Campanini]

Re: passing a string or building a string for testing

"sparks" <sparks@anywher e.com> wrote in message
news:jmnv51909q s13e758tv5evsak kp04g3to2@4ax.c om...[color=blue]
>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("questio n" & 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[/color]

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

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

If IsNull(Me("ques tion" & i)) Then

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

Bruno

[sparks]

Re: passing a string or building a string for testing

Thank you VERY much for pointing that out to me.


On Fri, 15 Apr 2005 16:05:01 GMT, "Bruno Campanini" <bruno.campanin i@tin.it>
wrote:
[color=blue]
>"sparks" <sparks@anywher e.com> wrote in message
>news:jmnv51909 qs13e758tv5evsa kkp04g3to2@4ax. com...[color=green]
>>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("questio n" & 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[/color]
>
>When you write:
>If IsNull("questio n" & i & ".Value") Then
>
>I suppose "question" & i stays for a field name in your form.
>If so you must write:
>
>If IsNull(Me("ques tion" & i)) Then
>
>This is a rare case requiring Me, which is normally
>a redundant word.
>
>Bruno
>
>[/color]