0.004cm column width for value list combobox not working

hey guys,

i've got a combobox which is populated by a value list Credit;C;Debit;D

column count is 2
column width is 2cm;0.004cm

i'm trying to hide the 2nd column - but because it's a value list i must put column count 2 if not instead of 2 chooseable values in the dropdown it will become 4.

however even though i put 0.004cm, it still shows. in the table lookup field and also in a form combobox.

i can't solve the table lookup field scenario but i can solve the combobox in form scenario - set the column width to 6cm;0.004cm when the combobox width itself is 6cm.

is this a bug that yall face as well guys? thanks!! = )
developingprogrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IrogSintaCommented:
Why not put just 0 instead of 0.004cm?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
developingprogrammerAuthor Commented:
omg IrogSinta you're a genius and i'm so dumb ha

i kept thinking that to hide columns i need to be able to exclude it from the column count. that solved everything. thanks so much IrogSinta, so so sleepy again ha. thank you
0
developingprogrammerAuthor Commented:
hrmm IrogSinta do you think there are any benefits of doing

column count = 2
column widths = 2cm;0cm

versus

column count = 1
column widths = 2cm

?

of course given that the row source is a table / query.

i'm thinking that there might be value always defining more columns and then manually setting it to invisible by using the column widths property.

what do you think?

i can't think now but will think tomorrow ha. goodnight
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

developingprogrammerAuthor Commented:
ya i think there is value in defining the max column count and then manually hiding it using column widths because it forces us to be aware of the columns that are available to us to use as bound columns. slightly more typing but more awareness is better i believe
0
IrogSintaCommented:
Why would you put all the columns if you don't need to refer to them at all? If you find out that you need an additional column later on, then it's pretty simple to revise your column count & width properties at that point.  If you think there's a chance that you may use a certain column, then just include it from the onset. Adding all the unused columns brings no benefit that I can see.  To find out what columns are available, one simply looks at the RecordSource.
0
developingprogrammerAuthor Commented:
ok great point. thanks so much IrogSinta!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.