Numbers instead of words!

[AlanGNW]

I'm trying to pull fields from a table into a form - and have had other problems with this.....

What is textual information in one table. ie. the table I am trying to acces from a drop down will only appear as numbers instead of the text entry in the original - I have triend the bound colums but these are correct?

I've had this problem at a couple of points - it seems to be formatting the forms as numbers and pulling in the record numbers rather than the textual information. The bound colums are pointed at the textual entries but I can not change the formatting in the forms etc to text rather than number... In the drop down it shows the text entries but will not allow them to be saved when updated?

 

[aleb]

can you post a db?
Sounds like you have problem with bound columns

 

[AlanGNW]

Thanks for the reply. I did find it eventually and you are right about the bound colums... Now having problems pulling tables into Excell with a similar result - even though the bound colums are set right...

 

[aleb]

Hmmmm ... I am not sure what is the problem.

As an example I am giving you what is in my db. When I went Tools,Office links, Analyze with Excell it worked like a charm ... no problems
See attachment -the "ContractID" field is number yet it displayes the text ... when I output the table everything is great.