I want to make visible a specific text if a persons age is between two numbers, like this:
I have tried diffrent things, but have not figured it out.Code:If Me.Age = Between 20 and 25 Then
I thank you for all help.
Make visible a specific text if a persons age is between two numbers
Novice
Windows 10 
Office 365
I want to make visible a specific text if a persons age is between two numbers, like this:
I have tried diffrent things, but have not figured it out.Code:If Me.Age = Between 20 and 25 Then
I thank you for all help.
Access Developer
Windows 10 Access 2016
I think Between is best for dates.
You could use something like:
Me.Age >= 20 And Me.Age <= 25
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Virtually Inert Person
Windows 10 Access 2016
You cannot use Between in vba?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Novice
Windows 10 Office 365
Thank You, Bob. This works just fine
The problem is solved.
Novice
Windows 10 Office 365
Micron.
The first tip I got works fine, I do not use "Between" in the code.
My problem is solved.
How to make a description visible in a form text box and then disappear when you type in the box.
Long Text/Memo field -- Make Border Visible
Code if statement to make specific rows in list box not visible
Make a text box visible and populated after update of combo box above it.
Posting Permissions
Reply With Quote