field not showing control source information

  • Thread starter Thread starter Lila
  • Start date Start date
L

Lila

I have a table that has a field called [Perm_PermitLocation] that is
formatted as a number and uses a combo box to get the text list from another
table. The table has about 1000 entries

I have a query that narrows the list to about 50 entries. The query shows
the field as the text, not the number.

I wrote a report that draws it's information from the query. I want to show
this field as a number, not the text. Not everyone knows that 1="city" and
2= "county". I've tried writing an IIf statement in the Control Source of
the field in the report, but it keeps returning Error.

Am I doing something wrong? Maybe a formula isn't the correct solution...
maybe I'm missing a simple formatting step. Help!!!
 
From what you have given us, the query must have [Perm_PermitLocation] in a
table/query upon which the query is based. You have but to place
[Perm_PermitLocation] in a query field.
I have a table that has a field called [Perm_PermitLocation] that is
formatted as a number and uses a combo box to get the text list from another
table. The table has about 1000 entries

I have a query that narrows the list to about 50 entries. The query shows
the field as the text, not the number.

I wrote a report that draws it's information from the query. I want to show
this field as a number, not the text. Not everyone knows that 1="city" and
2= "county". I've tried writing an IIf statement in the Control Source of
the field in the report, but it keeps returning Error.

Am I doing something wrong? Maybe a formula isn't the correct solution...
maybe I'm missing a simple formatting step. Help!!!
Click to expand...
 
Hmmm... I deleted the [Perm_PermitLocation] placed by the report wizard and
put it back in by dragging it from the field selector and it was fine.
Must've been something to do with the wizard!

Thanks!

jahoobob via AccessMonster.com said:
From what you have given us, the query must have [Perm_PermitLocation] in a
table/query upon which the query is based. You have but to place
[Perm_PermitLocation] in a query field.
I have a table that has a field called [Perm_PermitLocation] that is
formatted as a number and uses a combo box to get the text list from another
table. The table has about 1000 entries

I have a query that narrows the list to about 50 entries. The query shows
the field as the text, not the number.

I wrote a report that draws it's information from the query. I want to show
this field as a number, not the text. Not everyone knows that 1="city" and
2= "county". I've tried writing an IIf statement in the Control Source of
the field in the report, but it keeps returning Error.

Am I doing something wrong? Maybe a formula isn't the correct solution...
maybe I'm missing a simple formatting step. Help!!!
Click to expand...
Click to expand...
 
Back
Top