Search results

Great. Thank you that worked. What about if I want to put the city on one line and the state on the other. Then what would I type in? Thanks

dk, Take a look at this attachment. This is what my report looks like in design view. I really appreciate your time. I am not an expert by any means in Access, so some of your instructions are foreign to me. I just tried this last command and it did no seem to work. So, do you think that maybe...

Hello, I am wondering how to go about combining 2 fields on a report. Here's is an example of what I am trying to do. Lets say I have a field called city and a field called state. On the report instead of having 2 fields print out, one for city and one for state, I would like to know if I...

Nope. Same thing. The field names are correct. The Enter Parameter Value window shows vbcrlf as the command that it does not understand. Could it be because I am using Access 2003?

Okay, SO now it took, but when I run the report it comes up with a Enter Parameter Value Box. Is the text between the & symbols supposed to be vbCrlLf. In other words, is that a small L and then a big L?

DK, I have 2 fields (Address and City) The one called City is really the City and State in one Field, for example Gilroy, CA. Okay, I went to the Control Source on the Address and changed it to the following: = [Address] & vbCrlLf & [City] & For some reason, it does not save this info in...

Okay. Thank you all. I will give it a try and let you know what happened. Thanks again.

Hello DK, So forgive me for being stupid but how exactly do I do this. Do I go to the properties of the Address Felid and enter the statement you gave?

Hi Ken, You are right. I got nowhere last time. So here is the deal. The city, Gilroy, CA is indeed right below the Address, 7030 Rossanna St. The problem is, becuase the Occupancy Check feild has so much data in it, it automatically moves everything else down. I know I did not mention this on...

Hello Everyone, I am trying to make a report look better than it does now. The problem I am having is that the line spacing on one feild is being affected by the spacing of another. Take a look at the jpg that I have attached. This is explains it much better. Thanks in advance. Vince

How would I go about combing them on the report? Could you kindly tell me how? Thanks.

Hello Everyone, I am trying to make a report look better than it does now. The problem I am having is that the line spacing on one feild is being affected by the spacing of another. Take a look at the jpg that I have attached. This is explains it much better. Thanks in advance. Vince