blanks in report

[2bulent2]

hi
i have a report. names are automatically written to the report from a table. But as the names have different length i have to put a blank suitable for the longest name. So when a shot name is put to the report there redundant blank. Is there a way to automatically adjust the blank.

Like this:

my name is .............. I am from ....... My hometown is ....
I hope I could make myself understood.

 

[lameid]

Sounds like you have a control for each field. You can instead combine everything into a single control by combining fields using a technique called concatenation...

Control Source

= "my name is " & [Name Field] & " I am from " & [Country Field] & " My hometown is " & [City Field]

You will of course have to substitue your appropriate field names in the square brackets [Blue][][/Blue] above. I of course am guessing you meant country instead of say state or republic.

 

[2bulent2]

thanks
but i am not programmer and dont know about controls
and in fact i dont much about access

in access i added textbox tool to the report where will i add this code

 

[lameid]

If you added a text box in design view you can right click it and select properties.

Put the code in the line that says control source (I think it is the second line or towards the top anyways).

 

[2bulent2]

ok, i will try

 

[2bulent2]

i made a sample databse and added the code to the control source in text box porperties. but it didnt work it didn't show the field value.

in fact my report has a longer text.
i send the link of the mdb file.
it is in turkish. if you like i can send it with english office.

for example in "kabul onay" report, in the third line of the first paragraph after "T.C nolu özürlü " there is a text box adding the özürlü field from the "bakim_tablo" table.

if you want i can send the text in english.

 

[2bulent2]

http://rapidshare.com/files/274608938/pro_bakim.rar.html

 

[lameid]

I did not open the file but it sounds like you need to either make the control wider or set (make it true/Yes) the can grow property (much like where the control source property is).

If you use the Can Grow property, you will also likely need to set it on the section where the control is. This is the Band above the white area where the control is. For Example, every report has a detail section.