Viewing a form

The UK's most regular instructor-led training courses.
Training information: access class ms training · Microsoft access courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2003

3 posts

ReplyFri 23 Oct 2009, 09:33Delegate Suzanne said...

Suzanne has attended:
Access Intermediate course

Viewing a form

I have tabs set up on my form, but you can not see all the information. I do not have a scroll bar on the right hand of the page. Can you please help?

Thank you.

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

755 posts

ReplyMon 26 Oct 2009, 09:10Trainer Stephen said...

RE: Viewing a form

Hi Suzanne

Thanks for your question

The implication of your quesion is that the tabs are too large to fit on your screen. I suggest tring the following

1. Reduce the sizes of your tabs by grouping controls more closely together.
2. Check on your form properties sheet and confirm that the scrollbars property is set to "both".

If you still have problems, please let me know so we can explore other options

Regards

Stephen

Thu 5 Nov 2009: Automatically marked as resolved.

· Access Corruption Avoidance Tip #3: Stay Connected
· Get More Out of MS Access Courses
· Taking Control Of Your Data - And Saving Money In The Process!
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· A Quick Intro On How Access Uses SQL

Please browse our web site to find out more about
access class ms training and other Microsoft training courses.

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###�s.

You could widen the column to make the date and time show, but sometimes this is not convenient: the column may already be exactly the width you want to accommodate all entries in cells further below. Maybe you don�t want to push any other columns any further to the right, because you won�t be able to see the column contents on one screen, or because it forces you to change the print settings.

The solution is to use the TEXT function to convert the value returned by NOW to text: text (as opposed to a value) stretches into the next column rather than returning ###�s. The TEXT function has two arguments: 1. the value to convert to text; 2. what format to show it in. Use custom number codes in double quote marks to specify the format. For example =TEXT(NOW(),�ddd dd/mm/yy hh:mm�) will return date and time using the format FRI 09/04/04 11:24.

View all Access hints and tips