How to add space between lines in a report through a value in a field in the settings table

[Safaa]

If I have a report that I want to make available to change the space between each line and the next with a specific number, it will be put in a form in the settings.

 

[Safaa]

???

 

[Safaa]

any one can help ?

 

[GPGeorge]

What would that report look like? Please help us understand the required output by providing a mock up of the result you want so it can be compared to the current report. Show us the "before" and "after" you want. Thank you.

Also, you provided three tables which are "spreadsheet" designs, not relational database tables. This is going to be a problem. I suggest you pause and learn how to normalize your tables before investing a lot of time in creating reports, or forms, etc.

Search here and across the internet for "database normalization". Many good discussions will be found that can help you correct the current table design flaws.

 

[Safaa]

Just like this

 

[isladogs]

From your video, it appears you have already done this.

 

[Safaa]

From your video, it appears you have already done this.

THIS IMAGE NOT FOR ME

 

[theDBguy]

THIS IMAGE NOT FOR ME

I could be wrong but this feels like a school project to me. The image in the video is very similar to the one in the attached file, which suggests it's either an example video from a classmate or the professor. Just my 2 cents...

 

[mike60smart]

Just like this

But Why? would you need to do this?

If you print the report as it is with no additional spacing it would print 1 page only.
If you increase the spacing it will then print 2 pages.

 

[Safaa]

But Why? would you need to do this?

If you print the report as it is with no additional spacing it would print 1 page only.
If you increase the spacing it will then print 2 pages.

When the additional spacing is simple, we will not need two pages
The picture belongs to a person in an Arab forum who offered the solution for some money. I want to control the spacing between the lines. Can you do it for me for free?

 

[mike60smart]

The picture belongs to a person in an Arab forum who offered the solution for a fee. I want to control the spacing between the lines. Can you do it for me for free?

But my question is "Why do you need to do this?"

 

[Safaa]

But my question is "Why do you need to do this?"

When the analysis is only a blood picture, the distance between the lines can be widened or left as it is, but when there are other tests related to the same analysis, the distances can be narrowed to print them in one report. I saw it in one of the programs and I would like to do it.

 

[mike60smart]

When the analysis is only a blood picture, the distance between the lines can be widened or left as it is, but when there are other tests related to the same analysis, the distances can be narrowed to print them in one report. I saw it in one of the programs and I would like to do it.

There is no need to mess with line spacing in a Report.
If you have related data then this can be added to the Report quite easily.
However, the problem you have is that the data in your tables is not normalised.

How have you been adding data to the tables? If you are doing this by just opening a table and adding the data, then this
is the wrong way to go about it.

Data Entry should be entered by the use of a Form for your Parent data with a Subform for any Related data.

Can you explain the reason for the database?

 

[Safaa]

There is no need to mess with line spacing in a Report.
If you have related data then this can be added to the Report quite easily.
However, the problem you have is that the data in your tables is not normalised.

How have you been adding data to the tables? If you are doing this by just opening a table and adding the data, then this
is the wrong way to go about it.

Data Entry should be entered by the use of a Form for your Parent data with a Subform for any Related data.

Can you explain the reason for the database?

It is certain that I have a data entry form, but I did not attach it to the base because it is not important. I think I have made my request clear and there is no point in asking too many questions.

 

[mike60smart]

It is certain that I have a data entry form, but I did not attach it to the base because it is not important. I think I have made my request clear and there is no point in asking too many questions.

Ok If you are not willing to take advice then luck with your project.

 

[Safaa]

Ok If you are not willing to take advice then luck with your project.

I have one and only question: Can you do what I asked? If you cannot, then leave the opportunity to others. I did not ask for advice on my project. All I asked for is this. If you do not know, there is no shame in saying it.

 

[DHookom]

This could probably be accomplished with a huge amount of code since your tables are not normalized. There are about 60 fields from the HGB to the end that are all tests with a result and every one of these should create a record in a table. I recommend you do some research on Normalizing database tables.
I expect the answer to your original question would be much simpler (along with other tasks) if your tables were normalized.

 

[CJ_London]

The picture belongs to a person in an Arab forum who offered the solution for some money. I want to control the spacing between the lines

If you are not prepared to take the advice on normalising your data and the resultant relatively easier way of accomplishing your objectives then I suggest pay the person. You are unlikely to find anyone here willing to help you down a road to nowhere - at least not for free. Or try another forum

 

[Safaa]

This could probably be accomplished with a huge amount of code since your tables are not normalized. There are about 60 fields from the HGB to the end that are all tests with a result and every one of these should create a record in a table. I recommend you do some research on Normalizing database tables.
I expect the answer to your original question would be much simpler (along with other tasks) if your tables were normalized.

Make the code work in one or two lines and I will complete

 

[GPGeorge]

As others have noted, the tables you supplied in the sample are "spreadsheet" designs, not relational database tables. That makes everything you do exponentially harder, and also creates vulnerability for the integrity of the data. In short, that is the problem which needs to be addressed, not a nice enhancement to a report (which many would argue isn't really all that much of an enhancement).

Code to insert spaces between controls on a report could be written, yes. But people who participate here do so voluntarily for several reasons. Two of those reasons are that a) we like to share knowledge and experience with other Access developers as a way of paying back help we've received in the past from others, and b) we want to help increase the overall professionalism of those in our business.

Together, that means we'll always provide advice -- for free -- which has the best chance of achieving good results.

As a result, it's not likely someone will offer to provide -- for free -- code for the report spacing thing, and not try to help you understand the much bigger problem that needs to be addressed in the flawed table design.