Convert text box to check box

Misa933 ho

New Member
Joined
Nov 28, 2019
Messages
7
Office Version
  1. 2007
Platform
  1. Windows
Hiii
When I put Yes value in text box, automatically check the check box in form
It is just opposite of check box to text box
 
If I understand, you want 6 rows on a report page regardless of how many records there are. So if only 4 records, add 2 blanks. If 8 records, have 6 on one page, 2 on page 2 + 4 blanks on page 2. This or any variation of it is possible, but very difficult. If you research something like 'ms access report with blank rows' you will get lots of solutions, none of which are simple. The main problem lies in determining how many records there are then calculating how many blanks to add. If interjecting a page break in the report also, it starts to get VERY complicated. Most of these difficult solutions are code based and some people report that it works in one view but not another (report view versus print preview).

Another approach would be to use a table that is for this purpose only. Your query would add the records to it but you would also have to UNION (a query type) the required number of records to get the desired number, then open your report based on this table. When you close the report, you'd delete the temporary records. If I'm correct in how I interpreted your requirement, you'd still need a page break control in the report section and a control that counts the records in the section and code to show or hide the page break accordingly.

If none of that makes sense, you have a lot of learning to do to make this work, or you will have to contract this out as a job.
Thanks
 
Upvote 0

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,214,935
Messages
6,122,337
Members
449,077
Latest member
Jocksteriom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top