I browsed a lot of posts related to fonts, and pored over my "Mastering Access 2000" and "Access 2000 Power Programming" books, but I couldn't find answers to my specific questions.
I have many years of experience with Access, but I've only recently become interested in making my forms look nice on a variety of user PC configurations. Now, like many others, I sometimes spend too much time formatting a form so it looks really nice on my PC, only to find formatting problems on the user's PC. For example, a label using Arial Rounded MT Bold looks great on my PC but is cut off on the user's PC. Similarly, Tahoma on buttons looks nice on my PC but looks bigger and bolder on the user's PC.
At first I thought this was probably a font problem. But then I realized that even with the same screen resolution, the forms themselves (not just the fonts) appeared bigger on the user's PC. Some forms didn't even fit inside a maximized Access window, whereas they certainly did on my PC - again, this is with the same screen resolution. So now I don't know if it's a font problem, some other problem, or perhaps multiple problems.
Which leads to my questions:
(1) If I set the size of a form on my PC, and the screen resolution is the same on my PC and the user's PC, then why does my form show up relatively bigger on some users' PCs? How can one control the look of a form if the form properties are not applied identically on different PCs?
(2) Why do all the fonts look bigger and fatter / bolder on some users' PCs?
(3) Is there a user-configurable Windows setting that overrides the font size settings I assign to controls?
(4) How can I determine in code if specific fonts are supported (if this is a necessary step)?
(5) What is the industry best practice for managing font selection, allowing for the possibility that the desired fonts may not be supported?
How can I control the size of my form. I would like some of my form with my program to open small, since they are small forms, and some large because they are the whole size of the forms. I hope I have explained this enough for someone to help.Thanks in advance.
Hi, I am a new member, who has been reading these postings for several weeks, hoping for a few quick answers, but no luck.
I have several issues on form size.
The first is that some of my forms open OK, but they change the form size of the form that opened them. My main form is maximized. When I open a child form, not maximized, the main form, and the open Access windows, such as the DataBase form and any open Tables, Queries, Reports, etc all become non-maximized.
The main form has the dimensions of the last-opened form .mde files, which leads me to believe that there is some Access option that crosses project or database lines. I cannot find it.
If I maximize the main form with the child form open, Access maximizes the child form also. If any form is open in Design View, the Properties window may be on top of everything. As the controls I need are seldom visible in these small windows, I spend much effort resizing windows.
What do I need to do to have a maximized "Switchboard" and smaller child windows/Forms???
I developed a report using Courier New font. When I print to a HP4050 from my computer the report is correct. When I print to the same printer from a different computer fields are truncated as if it is using a proportional font. Any idea as to whether this is a Windows or Access issue? Thank you in advance for any help...
I've recently started working on a new database and already have most of my forms, queries and reports ready. However, I've been using a special font that is not available on most PCs. I was wondering whether it was possible to save the font inside the MDB file so that it can be viewed properly on other systems as well ? (Sort of like in Powerpoint).
Another thing (I guess it's impossible but I'll ask anyway) : Is it possible to save the whole Windows Style design (Scroll Bars, Arrows, Icons, Menu colors, etc..) in my database file ?
I'm using a certain font - Guttman Yad-Brush (Hebrew, comes as a part of windows in Hebrew) in some forms and reports. On the design view of the objects, everything is OK. But when I try to display the form, or a print-preview of the report, Access refuses to show me that font. The text is clearly visible, in Hebrew, but in another font (I think Times-New Roman, but not sure).
The font is well installed, and works fine on other Office applications. Couldn't reproduce this behaviour with other fonts (but obviously haven't tried them all).
I'm using Access 2010's DoCmd.OutputTo in VBA to export reports to PDF. The "look and feel" of the PDFs are very important, as they will be distributed to clients of my company. I'm using special corporate fonts that are legally licensed for embedding as a subset. Two are .ttf (TrueType) and two are .otf (OpenType) fonts. The ttf fonts embed fine; the otf fonts do not, and the PDF viewer substitutes something it thinks is close (but really isn't). In the properties of the fonts in Windows Control Panel, the embedding properties are exactly the same for both.
Any way to force the fonts to embed? or any other workaround? Also, is there any way to edit-protect PDFs with VBA code? Or apply any other type of PDF security such as requiring a password to open?
I have database that is linked to an asp style website. In my Products table, I have a field for Product_Description. Unfortunately the descriptions for the products that I have are very lengthy, some 10 sentences and above. And as access only allows for field sizes of 255 characters max, I can barely fit 1-2 sentences here.
I was wondering whether there is a way of getting a much bigger field size at all?
I have a report that i export to pdf from access 2010 using OutputTo. The report is about 10 pages long. Every time i run this report, at page 5 and beyond, random letters become distorted, sometimes with a box sometimes with a question mark. All fonts I've tested are embedded. Times New Roman, Calibri, Arial, Georgia and others.
Attached is a sample of of the distorted pdf output.
I have a multiuser database back end with approximately 25 tables. The file size for the back end has recently jumped from approx. 50mb to 270mb, but I do not know where the data causing this increase is placed. Is it possible to measure the file space usage (in mb) that each table contributes so that I can determine the source of the increase.
I need to give users the ability to change the font of a field in a report. The field shows a barcode.
I thought of using the CommonDlg class to show the Windows font-selecting dialog box, but installed barcode fonts show as a barcode. I need to show the font name.
So I need to populate a combo box with the names of all fonts installed on a computer. The fonts reside in C:windowsfonts
I have searched Google for a solution but cannot find one.
How do I populate a combo box with the names of all fonts installed on a computer?
How can i make all my forums fill my screen? so dont have to recreate them? so they are not just tiny boxes. as originaly designed? I looked in hope that there maybe have been something in the startup drop drop down, but i was't so luck. also tried to select whole forum and group and name the whole thing bigger by dragging the resize command. but this just messed the whole forums up so i did't save changes.
Well, today I had a problem with my main access db. It stopped letting me create MDE files, and my usual trick of decompiling it didn't work. I eventually got it working by importing everything into a blank database and setting the startup form and references again. However when I did this, I noticed a very big difference in file sizes. My old MDB file was 14mb, while the new one was about 5mb.
Just wondering if anybody else has come across anything like this before? Everything seems to be working fine and transferred over corrrectly, but such a huge difference worries me slightly.
i am developing a clothing order management database.
I have so far got [order details], [products], [product details] entities. This is so that products with the same model code can have a selection of colours and sizes which are held in the product details table.
I followed this website which was very helpful: http://www.princeton.edu/~rcurtis/ul...database2.html
The question is now: each size and colour will have a different stock quantity. How do i model this, for example, so when a Small Red t-shirt is added, the small red t-shirts quantity decreases rather than the overall quantity for the model.
After much work and help from a lot of competent ppl on this forum i have finally been able to get my dB together. Now i have a problem though which i can't solve. Problem is this: I open a form, lets call it MENU. From this you open a second form called NewEmployee. In this new form you insert new data about the employee(s) and then insert them in the dB. So far so good, but when you do a print about the employee, the procedure is this: A special form is opened (PrintOutForm), its fields are filled with data from the NewEmployee, it is printed and then closed. Problem with this is that the MENU form is now not-maximized :) Which it was when you opened the dB.
Is this something any of you guys have encountered before?
I have written a database application in Access 2003 for my company. I am going to deploy it with Terminal services on a Windows 2000 Server. I went to my server room to logon and test and found that 90% of the screens I designed had print and close command buttons that were off the screen. I developed the application on a 19" plat panel display with 1280 X 1024 res. The server room has a 17" Non-flat panel with 1024 X 768 res. I am assuming this is the culprit. Is there a way to make the application a "ONE SIZE FITS ALL" solution. Im sure writing a different version for every possible resolution is not how it is done. Any ideas would be deeply appreciated
I have an Access Database of around 8MB. However, after a day's use, this file size increases to around 110MB. If I run a Compact and Repair, the file returns to it's usual size. The first time I noticed this, the file had reached a size of 2GB which is a bit alarming. The file does get used but only appending around 50 records a day and making some amendments. What could be causing this increase?
Is there a means of making an application grow/shrink to accommodate different screen sizes? eg. not all users of a distributed application will necessarily have the same screen size.
Using Access 2010, I have a subform in datasheet view and I want to set the font size to 10pt. Setting font sizes for datasheet fields in the Format tab does not change the font size displayed.
I understand that the font size can be set using VBA (for example: Me.DatasheetFontHeight=10). Where do I put this code for it to work in a) a single datasheet b) all datasheets in the db?
I have not done much work in later version of Access. Now I found if I change a design in one form and similar forms (names are different) which are linked to the same tables got changed as well without openning them up and making changes. Is this something new with Access 2003?
I'm using the following code to set text box fonts in all my forms. Problem is a couple of my forms have a combo box which I need to reference here but not sure how. I want the Combo Box font to be the same as the text box's. Not sure how to check to see if the control is a combo box.
Code: Public Function TextBoxProperties(frm As Form) Dim ctl As Control On Error GoTo TextBoxProperties_Error For Each ctl In frm.Controls If ctl.ControlType = acTextBox Then ctl.FontName = "Calibri"
I'm trying to make a database table for a sneaker inventory display/controller, it will be displayed on website using Dreamweaver to pull out the records. I can't figure out how to have a "size" entry in the table, let me explain:
Here is the problem, I need a "Size" field in there, but a sneaker will have multiple sizes (i.e. 6-11) and each size will have different quantities. Is it possible to incorporate a "size" field in my current table? or should I re-do my table in another way? How?
how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.
I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.
=Sort_1("Sort_1_Query1","LAST_NAME")
This is the Public Function Public Function Sort_1(SortName As String, FieldName1 As String) DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'" End Function
I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.
