UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> "emptycell" On Form, Access 2016    
 
   
lburmz
post Jan 23 2020, 11:05 AM
Post#1



Posts: 13
Joined: 31-December 18



I have a fairly complex form, and in a module I cycle through all of the controls in the form that meet certain criteria, one of which is being Visible. Recently it has started throwing the following error:

Run-time error '2455':
You entered an expression that has an invalid reference to the property Visible

The name of the control is "EmptyCell315"

The curious thing is, there is no such control in the properties window of that form.

Does anyone know how I can find and remove the EmptySpace?

Go to the top of the page
 
theDBguy
post Jan 23 2020, 11:31 AM
Post#2


UA Moderator
Posts: 77,505
Joined: 19-June 07
From: SunnySandyEggo


Hi. Sounds like you have a "layout" applied to your form controls. You can remove the layout or simply add an error handler to your code or check the names or types of the control before doing anything with them to avoid getting the error.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
lburmz
post Jan 23 2020, 11:36 AM
Post#3



Posts: 13
Joined: 31-December 18



OK, any ideas how I find the control which is in a layout when it doesn't exist in the Property Sheet control list?
Go to the top of the page
 
theDBguy
post Jan 23 2020, 11:56 AM
Post#4


UA Moderator
Posts: 77,505
Joined: 19-June 07
From: SunnySandyEggo


Hi. I just tried to create an Empty cell, and it showed up in the dropdown list, so I am not sure why you can't see it. Can you post a copy of your db?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
lburmz
post Jan 24 2020, 04:28 AM
Post#5



Posts: 13
Joined: 31-December 18



I'd rather not since it's for work. Can I upload it to onedrive and share the link with you privately?
Go to the top of the page
 
theDBguy
post Jan 24 2020, 09:31 AM
Post#6


UA Moderator
Posts: 77,505
Joined: 19-June 07
From: SunnySandyEggo


Of course. My email address is below.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
lburmz
post Jan 25 2020, 11:59 AM
Post#7



Posts: 13
Joined: 31-December 18



Problem solved, thanks to theDBguy.

Turns out I did have an empty cell with "layout" applied. I hadn't spotted it because it was on a tab/page of the form I didn't think to look on. Also, the name of the control (EmptyCell315) only appears in the Property Sheet drop down list when the control is actually selected.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th February 2020 - 07:34 PM