| Author |
Topic |
|
whill96205
Starting Member
46 Posts |
 Posted - 2004-07-07 : 12:03:30
|
| Whenever I create a subform and have it display data from another table, the font size appears to default to 10 pt. I would like it to be smaller, but there is no font format option for a subform in Design View. I *can* change the font size when I am in Form View, but it will not "save" that way -- it always goes back to being 10. Anyone know how to get this done?THanks,Whill |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-07 : 13:29:08
|
| When you create a subform, it actually creates another form. Look at the properties and you'll see what form it's pointing to. You need to then open that form up and change the properties there.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
whill96205
Starting Member
46 Posts |
Posted - 2004-07-07 : 14:52:37
|
| Hmmm...In Design View, I can check the Properties of the Subform, but the data source is simply another SQL table which I created. I don't see where there's another form that the system created and to which this subform is pointed....--Whill |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-07 : 15:05:40
|
quote:
Originally posted by whill96205
Hmmm...In Design View, I can check the Properties of the Subform, but the data source is simply another SQL table which I created. I don't see where there's another form that the system created and to which this subform is pointed....--Whill
You sure it's not in datasheet view?what happend when you double click on the subform?Brett8-) |
|
|
|
whill96205
Starting Member
46 Posts |
Posted - 2004-07-07 : 15:34:25
|
| Nope - It's Design View. Double-clicking on the subform in Design View brings up the Properties dialogue. The Source Object is identified as my ORDER-DETAILS table. I don't see any way here to either change the font size of the subform, or find some other "virtual" form that SQL created to use as the subform.So, I'm still stuck. What am I missing here?--Whill |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-07-07 : 19:59:30
|
| Whill, When the form is open in datasheet view, simply change the font style/size on the toolbar. You'll need the Formatting (Datasheet) toolbar up when you do this. Then save the form and all is well..Tim |
|
|
|
whill96205
Starting Member
46 Posts |
Posted - 2004-07-08 : 11:02:51
|
| That didn't work for me. Here's what I got...I opened the form in Datasheet View, which presented me, in essence, with a grid of the SQL table that is the data source for the entire form. Clicking a little plus sign next to a row in this grid, the row expanded to show a representation of one of the subforms. (I have two subforms on the main form; only one of them appeared in this manner in Datasheet View.) I could then select this subform datagrid, change the font size, and save. Upon re-opening the main form, the subform was STILL in its default 10 pt font.So, the subform font couldn't be changed, PLUS even if it had worked I would only have been able to apply the change to one of my two subforms.Basically, changing the font in any view (datasheet, design, or form) only seems to affect the font in THAT view, and then only for the current session of that view.Maybe I'm still not doing it right...?--Whill |
|
|
|
whill96205
Starting Member
46 Posts |
Posted - 2004-07-08 : 13:42:09
|
 Hey, I just discovered that my so-called subform was not created as a proper subform. Although right-clicking and viewing its properties indicated that it was a Subform/Subreport, it appears to have been a text box with a table for a datasource...? I just re-created it using the Subform tool in the Toolbox, so now in Design View it it shows up with all the appropriate subform structure, etc., rather than as a big, empty box with a table name in it.AND... I was able to format the column width and the font... AT LAST!  Thanks for your patience with me,Whill |
|
|
|
|
Font size in subforms