Report contains address with blank lines (1 Viewer)

[Mike Hughes]

Report contains address with blank lines - STILL PROBLEMS

I'm still not getting what you got. I have attached a document with screen shots of the steps I took and my results.
Help please

Thanks Mike

 

[vbaInet]

You are getting a circular reference error.

Change the name of that textbox to txtAddress and you need the parentheses just as it was written in the post #20 or #18

Basically copy and paste the code from those posts and follow what is mentioned about using it.

 

[Mike Hughes]

I'm still not getting what the two of you got. Please see attachment.

Thanks Mike

 

[vbaInet]

Mike, this is the same screenshot you had in the post prior to your last.

I gave you extra information in my last post which you haven't followed.

 

[Mike Hughes]

That worked thanks to the both of you. Someday I'll learn how to use Access, I hope!

Mike

 

[vbaInet]

Glad to hear!