datasheet view font

[AccessIdiot]

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

[Rabbit]

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.

[AccessIdiot]

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]

This can be changed in the MS Access window under tools Options, Datasheet. You can also accomplish this in code if you would like.

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

[Denburt]

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

[AccessIdiot]

Thanks for the help Denburt! Answers don't have to be long. :)

[RebekahW]

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]

Good to know. Although I never did like the datasheet view, from a GUI stand point.

[AccessIdiot]

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]

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.

[Denburt]

Ah you got in under my last post lol oh well.

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.

Yeah select all, change font, ugh that would suck. Glad I could help.

Short story:
I was working under a certifiable DBA once and she was hand typing thousands of records so they could all be uppercase rofl. I had no idea, then she asked me to help, 5 min later and the task was completed, needless to say I thought she was going to hit the floor. Sometimes people don't take things like that to well but she was O.K. I love office automation, most of what I do makes life easier and of course work myself out of a job but hey, have you seen the commercial about the easy button?

[AccessIdiot]

lol. I've worked with Flash long enough to know that the answer to "is it possible to . . ." is always "yes". You just have to hope that the person who knows how (or wants to find out) read your post.

But then again, Flash is Macromedia/Adobe and Access is Microsoft so maybe the answer to the question isn't always yes. ;)

[Denburt]

I learned to say no a long time ago... ;) Sometimes what the clients want they just can't have or I don't want to do it. Then we just find another method to achieve the same results, and in most instances thats is the main thing that is important.