Convert text box to check box

Misa933 ho

New Member
Joined
Nov 28, 2019
Messages
6
Office Version
2007
Platform
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
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
4,258
This works if BOTH the checkbox AND textbox are on the form
Place in USERFORM code window
VBA Code:
Private Sub TextBox1_Change()
   CheckBox1 = (UCase(TextBox1) = "YES")
End Sub
 

Misa933 ho

New Member
Joined
Nov 28, 2019
Messages
6
Office Version
2007
Platform
Windows
Report No. 101​
Sr. Nopart IDdefectsizestatus
1.Pipecrack2accept
2.PlatenilNaNa
3.Platehole4reject
 

Misa933 ho

New Member
Joined
Nov 28, 2019
Messages
6
Office Version
2007
Platform
Windows
Report No 102​
Sr Nopartdefectsizestatus
1.Pipehole8reject
2.Pipehole2accept
 

Misa933 ho

New Member
Joined
Nov 28, 2019
Messages
6
Office Version
2007
Platform
Windows
Report No 103​
Sr Nopartdefectsizestatus
1.Platecrack5reject
2.Pipenilnaaccept
3.Platenilnaaccept
4.PlatePit2accept
5.Machinecorrosion6accept
6.Pipenilnaaccept
 

Misa933 ho

New Member
Joined
Nov 28, 2019
Messages
6
Office Version
2007
Platform
Windows
Hiii
I want to table of 5 rows and 6 column on a report of Access... For different report Nos. like report no 101, 102 and 103 on separate page.
In each report I want to show 5 rows and 6 column blank or filled or half filled as shown above in Report No 101, 102 and 103.
Kindly help...
 

Misa933 ho

New Member
Joined
Nov 28, 2019
Messages
6
Office Version
2007
Platform
Windows
H
Sorry - unable to help
How to create a report for table of 5 rows and 6 column but in some cases only 3 rows are filled remaining rows are blank..
And some cases 6 or 2 or 1 or all or non are filled or blank...
 

Forum statistics

Threads
1,078,101
Messages
5,338,242
Members
399,215
Latest member
jsowa

Some videos you may like

This Week's Hot Topics

Top