& Chr(13) Why Does it show up as an error

[richmond88]

Hi,

I have the following code:-

ParameterField.PromptText & Chr(13)
DisplayText = DisplayText & "Report Name: " &
ParameterField.ReportName & Chr(13)
DisplayText = DisplayText & "Has Current Value: " &
ParameterField.HasCurrentValue & Chr(13)

For what reason do the & showup in the code window with a blue line underneath them and a help tip as expression expcted.

Thanks

Chris

 

[ca8msm]

Because you haven't added another expression to the statement. If you want to include the expression that is wrapped on the next line, you would have to use "& _" rather than just "&".


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[richmond88]

Thanks for the reply,

I am sorry but it is the & before the Chr(13) that is the problem.


Chris

 

[ca8msm]

In that case it's because you haven't set PromptText to equal anything (you've just wrote an ampersand after it for some reason).


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[richmond88]

Thanks.

I missed a line of code above ParameterField.PromptText & Chr(13).

Once again

Many Thanks