If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error
I am trying to use a switch function on my form that reads as follows...
=Switch([Field 1]="1","Yes",[Field 1]="2","No") However, the results to this function always read... #Error I did some further testing and found that if I enter into my control source... =[Field 1] That I have the same problem; but, if I enter only the field name... Field 1 My information is returned and I have no difficulty. I am thinking this may be due to a missing reference in my Access library but I do not know which one and am not sure how to add it. Thanks in advance for any suggestions or assistance! P.S. - I also have the same problem trying to use IIf functions on my forms. |
#2
|
|||
|
|||
#Error
What is the data type of your field that is named Field 1?
-- Ken Snell MS ACCESS MVP "Jahlu" wrote in message ... I am trying to use a switch function on my form that reads as follows... =Switch([Field 1]="1","Yes",[Field 1]="2","No") However, the results to this function always read... #Error I did some further testing and found that if I enter into my control source... =[Field 1] That I have the same problem; but, if I enter only the field name... Field 1 My information is returned and I have no difficulty. I am thinking this may be due to a missing reference in my Access library but I do not know which one and am not sure how to add it. Thanks in advance for any suggestions or assistance! P.S. - I also have the same problem trying to use IIf functions on my forms. |
#3
|
|||
|
|||
#Error
text
"Ken Snell (MVP)" wrote: What is the data type of your field that is named Field 1? -- Ken Snell MS ACCESS MVP "Jahlu" wrote in message ... I am trying to use a switch function on my form that reads as follows... =Switch([Field 1]="1","Yes",[Field 1]="2","No") However, the results to this function always read... #Error I did some further testing and found that if I enter into my control source... =[Field 1] That I have the same problem; but, if I enter only the field name... Field 1 My information is returned and I have no difficulty. I am thinking this may be due to a missing reference in my Access library but I do not know which one and am not sure how to add it. Thanks in advance for any suggestions or assistance! P.S. - I also have the same problem trying to use IIf functions on my forms. |
#4
|
|||
|
|||
#Error
What is the Name of the textbox whose Control Source contains the
expression? It needs to be a different name than Field 1. -- Ken Snell MS ACCESS MVP "Jahlu" wrote in message ... text "Ken Snell (MVP)" wrote: What is the data type of your field that is named Field 1? -- Ken Snell MS ACCESS MVP "Jahlu" wrote in message ... I am trying to use a switch function on my form that reads as follows... =Switch([Field 1]="1","Yes",[Field 1]="2","No") However, the results to this function always read... #Error I did some further testing and found that if I enter into my control source... =[Field 1] That I have the same problem; but, if I enter only the field name... Field 1 My information is returned and I have no difficulty. I am thinking this may be due to a missing reference in my Access library but I do not know which one and am not sure how to add it. Thanks in advance for any suggestions or assistance! P.S. - I also have the same problem trying to use IIf functions on my forms. |
#5
|
|||
|
|||
#Error
Perfect! All I needed to do was rename the textbox. Thank you so much!
"Ken Snell (MVP)" wrote: What is the Name of the textbox whose Control Source contains the expression? It needs to be a different name than Field 1. -- Ken Snell MS ACCESS MVP "Jahlu" wrote in message ... text "Ken Snell (MVP)" wrote: What is the data type of your field that is named Field 1? -- Ken Snell MS ACCESS MVP "Jahlu" wrote in message ... I am trying to use a switch function on my form that reads as follows... =Switch([Field 1]="1","Yes",[Field 1]="2","No") However, the results to this function always read... #Error I did some further testing and found that if I enter into my control source... =[Field 1] That I have the same problem; but, if I enter only the field name... Field 1 My information is returned and I have no difficulty. I am thinking this may be due to a missing reference in my Access library but I do not know which one and am not sure how to add it. Thanks in advance for any suggestions or assistance! P.S. - I also have the same problem trying to use IIf functions on my forms. |
Thread Tools | |
Display Modes | |
|
|