Values in Combo Box not populating on some computers

[gruebz]

Hi,

Hopefully this is a really simple requiring a simple answer.... hopefully

On one of my forms I have a combo box thats values are generated by a parameter query. On my computer and a couple of others i tested it (on the same network) this combo box populates fine, but i put it on a couple of other computers today and it doesn't show any values. I checked and the query itself runs fine, plus a combo box that runs off a table populates fine.

not too sure if its relative but the database is split with the tables sitting on the network share and the database sitting on the main computer. or perhaps this could have something to do with blocking unsafe expressions.. i am not sure

any help on this would be greatly greatly appreciated

 

[boblarson]

Sounds like those computers might have Access 2003 SP1 and yours might not have the Service Pack. If so, what you need to do is to remove any formatting at table level and apply it at form level.

 

[gruebz]

cheers

at the risk of sounding dumb, what do you mean by "remove any formatting at table level and apply it at form level"?

 

[boblarson]

If you have any formats in the format property on any fields it the table, then you would want to move that to the format property of the control on the form that displays that field. For example, you might have > in the format property of a field to force it to display in all uppercase. You would remove that in the format property in the table and then put it in the text box's format property on the form.

 

[gruebz]

i think i'm with u... i'll give that a go and let u know how i get on

if it works ill be eternally grateful

 

[boblarson]

Good luck and by the way, Welcome to Access World Forums

 

[gruebz]

thanks.... just quickly... is it just the fomat field in the tables that i have to be concerned about?

also, without making u right a novel are there any other things of this type i should be concerned about regarding the service pack? i dont need a long answer here, i should be able to google the rest.

 

[gruebz]

ive removed all the formatting from the table but it still doesnt seem to work. maybe i should explain a little bit more about it the problems (which i just worked). this combo box that i said doesnt work is on a sub form of another form. however if i open the subform by itself it works fine.

sounds weird but any ideas?

 

[hamrthroer]

I had the same issue and moving the formating to the form from the table worked like a charm. Thanks!