Combo Box Problem

[daryless]

we have a 2008 Terminal Server running access 2003 and Word Excel ect running 2007 (So we export to excel with our reports)

Problem is that some combo boxes will display perfectly then one or 2 on a form will come up with the list empty

This one works
SELECT tblBranch.BranchDescription FROM tblBranch ORDER BY tblBranch.BranchDescription;

This one doesn't
SELECT Authorisation.AuthorisedBy FROM Authorisation;

I can run them both in an SQL Query and they work fine. Any ideas

 

[daryless]

we have a 2008 Terminal Server running access 2003 and Word Excel ect running 2007 (So we export to excel with our reports)

Problem is that some combo boxes will display perfectly then one or 2 on a form will come up with the list empty

This one works
SELECT tblBranch.BranchDescription FROM tblBranch ORDER BY tblBranch.BranchDescription;

This one doesn't
SELECT Authorisation.AuthorisedBy FROM Authorisation;

I can run them both in an SQL Query and they work fine. Any ideas

All fixed

We had the format for the field set to >@ which should just convert the text to upper case obviously in 2008 it doen't like it.