Hello all,
I have a subform that I want to be in datasheet view to be able to add multiple records. I have dragged and dropped the fields from the field list window and set the font to what I want. However, when I view the form the subform is in a default font and the column widths are not long enough to hold the names. How can I change the font and the column width?
thanks for any help
12 6716 Rabbit 12,516
Recognized Expert Moderator MVP
I don't know of a way to change the datasheet view, have you thought about continuous subform? It'll display information like a datasheet except you have more say over how it looks.
I thought with a continuous subform it just repeats the controls? I have four textboxes so something that looks like a table would be better, I just need it to have the same font as the rest of the page (company standard) and fit without scrolling.
Denburt 1,356
Recognized Expert Top Contributor
Sorry for my short answers i am super busy here today.
ColumnWidth can be found in the help file and more info in the link below: http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx
From the help file:
Forms![Customers].RowHeight = 450
Forms![Customers]![Address].ColumnWidth = -2
Thanks for the help Denburt! Answers don't have to be long. :)
You can change the font, color, gridlines and cell effects on datasheets (but not column widths) by going to Options in the Tools menu then choosing the datasheet tab. However, this will effect all datasheets not just the one in your subform.
Have you considered using a listbox control instead of a subform? I used to always use subforms and have fought with trying to format the datasheets as well until i figured out the listbox. It seems to me you have much more control over a listbox's aesthetics (including column widths) and you can change/edit the rowsource on the fly much like you would the Record Source of a form/subform. It also presents a wizard when you add it to the form, just like the subform, so the initial set up is a breeze as well if you choose to use it.
You might want to just try it and see what it looks like.
Rebekah
South Alabama
Rabbit 12,516
Recognized Expert Moderator MVP
Good to know. Although I never did like the datasheet view, from a GUI stand point.
I don't like the look of the datasheet either and would prefer continuous forms but in this case it works better as datasheet.
Basically this is a form where the user enters information about a specimen. But they might have 7 of the same thing, i.e. 7 catfish and the only difference is their length. So instead of filling out 7 forms for the same thing they fill out one form:
species: catfish
age: adult
state at time of capture: dead
state at time of release: dead
count: 7
and then a subform for the different measurements:
Standard Length
Fork Length
Total Length
So the subform in this case works best as a table with rows and columns.
I hadn't seen the options under, well, the Options tab (drrrr). Thanks for pointing that out! I was getting tired of Select All, change font. :)
Denburt 1,356
Recognized Expert Top Contributor
Personally I prefer the Datasheet view although I usually avoid it for my clients so I can add more bells, and whistles such as a button for a calendar for dates or something. I find most people aren't very keyboard savvy and would rather use a mouse. Where I find using continuous forms more of a headache tabbing and using enter versus the arrow keys.
Hello, RebekahW I agree if you are just browsing through records or searching for a record or records a listbox is pretty good and it is worth mentioning. Ya know we are practically neighbors... BTW, LOTS of my family down your way around the Mobile area and there abouts.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Keith Wilby |
last post by:
I have a form which allows both form and datasheet views. My question is,
is it possible to control the field (column) names in datasheet view? What
happens at the moment is that the name is taken from a control's label if
there is one, and if not, the control's name is used.
This is confusing for my users so I'd like to be able to use more sensible
names in datasheet view. Is this possible?
Many thanks.
Keith.
|
by: Kent Eilers |
last post by:
I want to follow naming conventions for my controls - i usually prefix combo
boxes with "cbo". When a form is in datasheet view however i do not want
the user to see the 'cbo' prefix in front of the field name.
Is there a way to retain this nomenclature and yet have the view display the
field name (or anyname i want for that matter)?
Thanks
--
|
by: Terry |
last post by:
I have created a Main Switchboard in Access 2000 and it has a button
which opens a Form. I have set the form Properties Default View to
Datasheet and this always opens in datasheet view.
When I open the Form from the Main Switchboard it always opens in form
view.
Can this be changed so that it always opens in Datasheet View?
Terry
|
by: Georges Heinesch |
last post by:
Hi:
I have a tables in relationship to each other. When I open the main
table (table 1), I see a "+" at the very left of every record. Clicking
on the "+" expands the data of the linked table (table 2).
Now ... when I create a form from table 1, I didn't manage show these 2
tables the same way (with the "+" at the left side of every record) as
it was shown as table. Access insists of making a regular form out of
table 1, but accepts...
|
by: Yuki |
last post by:
I am trying to find out if I can have a specific record that has been
selected in a list box be opened in datasheet view. I can't seem to
find where this can happen or what I need to use to make it happen?
Does anyone have any ideas? My list box is currently tied to an option
group so that they can sort the list box in order of how they want to
search for certain records. It is a maintenance form. I want the user
to be able to select...
| |
by: R. Hopping |
last post by:
I've changed the font size on the form but it only works in form view.
When the data is displayed in Datasheet view it doesn't display the
selected font size.
|
by: PeteCresswell |
last post by:
The following code is working for everything but the column formatting
on lines 9191 and 9192. It doesn't trap out - just doesn't "take".
"fChart" is a pointer to the open form that has the Chart object on it.
--------------------------------------------------------------
Dim myChart As Graph.Chart
9110 Set myChart = fChart!gphStats.Object.Application.Chart
9111 With myChart
|
by: sasan3 |
last post by:
when I set visible=false, then entry is not visible in form view, but
still shows up in datasheet view. How do I make a field not to show
based on some condition in datasheet view?
Tx.
|
by: Alan Forsyth |
last post by:
That rather long subject says it.
In Access97 running on XP - I want to display a Maximized size Form01, then
open a Restore size Datasheet View Form02 on top of the first Form.
PopUp won't give me Datasheet view.
Dialog mode won't give me Datasheet view
I could make Form01 Restore size and expand it to fill the Window in
Restore size (maybe DoCmd.MoveSize Right, Down, Width, Height) - I don't
want this.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |