 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / September 2008Appling Auto Format preset designs into my existing forms
Bit of a silly question, and no doubt a easy fix, but..... Have a program I made in Access 2003 converted to 2007 and would like to jazz it up a little in appreance. Opened my form, clicked "arrange" tab, clicked Autoformat and selected a new design. It applies the design colours, but they are only one block solid colour. ie, does not have the wave design behind it etc. Interestingly enought, I thought well I will just create all new forms! So I started by creating a form and again when i selected the autoformat I wanted, it would not display as I requested. It was just solid colour, no pattern design inthe header at all..... Any Ideas? Thanks Guys..... Meredith Hi Meredith, Do you have a visible form Header section on these forms? If not, make sure to show the form header section. Height > 0" Try the AutoFormat command again now and let me know the results.  SignatureJeff Conrad - Access Junkie - MVP Alumnus SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- > Bit of a silly question, and no doubt a easy fix, but..... > [quoted text clipped - 11 lines] > wanted, it would not display as I requested. It was just solid colour, no > pattern design inthe header at all..... Hi Jeff, thanks for the input, but no did not work. It is a Form Header. Height is set to 3.852 cm (tried to set at 0, but wouldnot accept 0 height. Other details from property sheet: Visable yes Height as above Back Color #383265 Special Effect flat Auto Height yes Can grow no Can shrink no Display when always keep together no force new page none new row or col none. All other "all" tab items are clear. Any other ideas? Just thought of something and tried it. Just started a brand new database. with a table and and form, and have the same problem occuring. IE, think maybe something to do with the program itself, not database specific. Is there a setting or something that I have undone?????? Cheers Jeff.... its an interesting one hey! > Hi Meredith, > [quoted text clipped - 18 lines] > > wanted, it would not display as I requested. It was just solid colour, no > > pattern design inthe header at all..... Hi Meredith, There are two issues with setting the AutoFormat in Access 2007. First, you must have a Form Header section that is larger than 0". You've already taken care of the first issue. (This is a bug in the program actually.) Second, you must select the form itself before clicking the AutoFormat command. If you do not do this step, Access does not apply the AutoFormat correctly. Make sure you have selected the Form itself before clicking the command. If you're not sure if you have the form selected, open the Property Sheet and select "Form" from the drop down list of form elements. Now click the AutoFormat command and you should be good-to-go. Let me know, SignatureJeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- > Hi Jeff, thanks for the input, but no did not work. > [quoted text clipped - 27 lines] > > Cheers Jeff.... its an interesting one hey! Ok, still not applying. selected form (checked on property sheet) applied and again still solid colour. Was looking at the access options. Cant see anything there. also looked at autoformat "more options" and my friend thinks there is something missing from my form autoformats list on the wizard. i have: Access 2003 & 2007 apex aspect autoformat1 civic concourse equity flow foundry median metro module none nothwind office opulent oriel origin paper solstice technic trek urban verve win vista. Thyink may have deleted one when i first transferred over. was messing around and can vaguly remember being in the wizard. cheers. Meredith > Hi Meredith, > [quoted text clipped - 42 lines] > > > > Cheers Jeff.... its an interesting one hey! Most odd. Are you running Service Pack for Office/Access 2007? Do you have more than one version of Access installed on this computer? Do you see the same issue with all AutoFormats, or is it only one in particular? SignatureJeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- > Ok, still not applying. selected form (checked on property sheet) applied > and again still solid colour. [quoted text clipped - 34 lines] > Thyink may have deleted one when i first transferred over. was messing > around and can vaguly remember being in the wizard. I know! I had 2003 office, but think i have uninstalled. I checked in program and features and had office 2003 web components. but no office 2003 that i can see. have sp1 installed. looked on update list and have all 2007 updates, but also office 2003 sp3? i think this should be uninstalled.? Yesterday I ran a repair on office pro 2007, but made no difference. ran autoformat in word, works a charm. Pain in the butt..... LOL. sorry about the hassle. any ideas? > Most odd. > [quoted text clipped - 42 lines] > > Thyink may have deleted one when i first transferred over. was messing > > around and can vaguly remember being in the wizard. Hi Meredith, Can you try another quick test for me? Do you have a Form *Footer* section showing as well? Make sure the Height is greater than 0 for the Footer and then try applying an AutoFormat again. Does it work now or no change? SignatureJeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- >I know! > [quoted text clipped - 10 lines] > > Pain in the butt..... LOL. sorry about the hassle. any ideas? Hey Jeff! Checked that before. Yep, I have a footer of 2cm. One other thing i just discovered........ i dont have layout view on anything in access. also did some more things, uninstalled office 2007 and all other office products on computer. reinstalled it all and access still same as before. Interesting thing, when i looked up layout view missing, it was going on about compatability mode.? my database was originally started on 2003, and imported or converted to 2007. database has extention of .accdb. i have checked access options box that says enable layout view mode, so its not that. interesting enough though, if i open say nothwind template i get layout view and can change the autoformat and they work as they are supposed to! How weird is that...... Anything else i can help aid your thoughts? Its really giving me the willies now! cheers mate, and thanks so much for your help thus far. > Hi Meredith, > [quoted text clipped - 19 lines] > > > > Pain in the butt..... LOL. sorry about the hassle. any ideas? JEFF, SOME GOOD NEWS! I GOT AUTOFORMAT! Did this! access button access options current database under picture property storage format, selected preserve source image format. (was on convert all picture data to bitmaps.... well go figure hey! Unfortunately still do not have layout view. so any idea there? > Hi Meredith, > [quoted text clipped - 19 lines] > > > > Pain in the butt..... LOL. sorry about the hassle. any ideas? Hi Meredith, Excellent, I'm pleased to see you were able to get the AutoFormats working. I'll probably make a new FAQ page on this subject in case other users run into the same issue. On your layout issue, open each form in Design View and look for a property called "Allow Layout View" on the form's property sheet. Change that from No to Yes and save the form. You should now be able to open the form in Layout View. SignatureJeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- > JEFF, SOME GOOD NEWS! I GOT AUTOFORMAT! > [quoted text clipped - 8 lines] > > Unfortunately still do not have layout view. so any idea there? > Hi Meredith, > [quoted text clipped - 19 lines] > > > > Unfortunately still do not have layout view. so any idea there? I have the same problem as Meredith but my settings in: > > access button > > access options > > current database > > under picture property storage format, selected preserve source image > > format. (was on convert all picture data to bitmaps.... were set correctly and my version of Office is not an upgrade nor is the database. When I apply autoformat to my form I got a solid block of colour in my header and not the wave that should be in the design. Ahhhhhhhhhh. I have followed all the advice on this thread but still have the problem. Please, please help. Many thanks. > Hi Meredith, > [quoted text clipped - 19 lines] > > > > Unfortunately still do not have layout view. so any idea there? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.