MS Access – Button Picture – doesn’t support this format … or the file size is too big

I came across the following post and wanted to see what the issue was since I routinely use Irfanview myself (it is a great, free no strings attached piece of software).

So I contacted the creator of Irfanview directly regarding the error, and he was able to pinpoint the exact nature of the problem.  As it turns out, the ico files created by Irfanview are just fine.  The issue is that MS Access would seem to expect a specific type of ico file (and doesn’t tell anyone this).

Irfanview creates a 24BPP (with no alpha layer) ico file while MS Access seems (based on my testing and returned information from Irfan) to expect a 32BPP with an alpha layer ico file.

So for anyone else ever seeing this this of error.  An ico is not an ico in the world of MS Access.  It is picky and requires a specific type of ico file.  So just be sure of the type of file your are creating is a 32BPP with an alpha layer ico and you should have no problems using them as a picture for a button.  Alternately, instead of having such issues using a ico file, use BMPs instead.  I personally don’t like BMPs as they aren’t used in any other programming (always jpg, gif, png, ico) so I will stay with ico so I can reuse them easily where I please.  It would be nice if MS would integrate common image files into the application, but that is out of my hands (if it were up to me many issues like this would have been resolve a long time ago!).

Hopefully this will help someone out.

One response on “MS Access – Button Picture – doesn’t support this format … or the file size is too big

  1. John Tsioumpris

    Well David, this was the day i encountered this strange error.
    Since i like the use of icons with transparency on my apps i use Greenfish Icon editor and never had an issue till today.
    I feared that my installation went corrupt as i did tried just about every combination but no luck.
    I consulted your article but again nothing..the complain was there and it just wouldn’t work no matter what…and my icons are 32bit with transparency…i had already icons on this app and i have “inserted” them just a few days ago.
    And then it hit me ! … i created a new blank Access, did a quick test, .ico gets accepted….hooray…imported the application …did one more test run ,everything seems to work..
    So if someone encounters this nasty bug maybe you have everything right but your copy has a bit of “a mind of its own”, so create a new Access and do some quick tests..if its OK then just import the old, if not probably you have some other issue

    JT