|
| 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
September 11th, 2007, 01:52 PM
posted to microsoft.public.access.forms
|
|||
|
|||
#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
September 11th, 2007, 02:54 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#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
September 11th, 2007, 03:46 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#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
September 11th, 2007, 05:48 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#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
September 11th, 2007, 06:20 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#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 | |
|
|
Linear Mode
