Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-14-2019, 07:43 AM   #1
JimL
Newly Registered User
 
Join Date: Jul 2019
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
JimL is on a distinguished road
Eliminate record count bar at bottom of a subform

Hello all,

I have a subform which will not be navigated (entire records will be visible at all times). I want to eliminate the frame and the record count bar so that the subform will look like part of the main form. Can this be done?

Thank you.

JimL

JimL is offline   Reply With Quote
Old 07-14-2019, 07:44 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,238
Thanks: 63
Thanked 1,678 Times in 1,633 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Eliminate record count bar at bottom of a subform

Hi JimL. If you go to the Design View of the Subform, you can set the Navigation Buttons property to No.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 07-14-2019, 07:52 AM   #3
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,387
Thanks: 40
Thanked 3,687 Times in 3,551 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Eliminate record count bar at bottom of a subform

I'll just add that to hide the frame set the subform control border style property to transparent

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 07-14-2019, 09:43 AM   #4
JimL
Newly Registered User
 
Join Date: Jul 2019
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
JimL is on a distinguished road
Re: Eliminate record count bar at bottom of a subform

Thanks to both of you for your replies.

Unfortunately, there is no Navigation Buttons property that I can find in the subform properties sheet (I am running Access 365).

Would it be of any help to send a screenshot of the "All" tab on the properties sheet?
JimL is offline   Reply With Quote
Old 07-14-2019, 09:47 AM   #5
JimL
Newly Registered User
 
Join Date: Jul 2019
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
JimL is on a distinguished road
Re: Eliminate record count bar at bottom of a subform

Eureka! Found the nav options when I right clicked on the subform rather than selecting the subform and looking at the properties sheet.

Can't explain why that happened.

Thanks again!
JimL is offline   Reply With Quote
Old 07-14-2019, 09:49 AM   #6
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,387
Thanks: 40
Thanked 3,687 Times in 3,551 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Eliminate record count bar at bottom of a subform

Quote:
Can't explain why that happened.
you need to click twice, the first to select the subform control, the second to select an object in the subform

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Reply

Tags
forms , subforms

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Record Selector at Bottom of Form. Place or mimic that in body of subform EmergentGuru Forms 4 09-12-2016 11:10 AM
Open a subform and display the last bottom record rickyfong Forms 11 07-11-2014 01:46 AM
subform record count gisler87 Forms 10 03-19-2009 12:07 AM
Record count in SubForm and how i can .... parara Forms 11 12-11-2007 05:57 AM
Record Count in a subform? ChampionDuy Modules & VBA 7 05-13-2002 07:28 AM




All times are GMT -8. The time now is 06:01 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World