I have 2 items to list in a pull down menu, but I want a third field left blank. Access won't seem to allow for that 3rd blank field.
Competent Performer
Windows XP 
Access 2010 32bit
I have 2 items to list in a pull down menu, but I want a third field left blank. Access won't seem to allow for that 3rd blank field.
Last edited by snowboarder234; 03-08-2018 at 04:45 PM. Reason: Resolved on my own.
Who is John Galt?
Windows XP Access 2007
Posting your solution may help somebody in the future. Presumably it involved a UNION query or adding a Null item.
Competent Performer
Windows XP Access 2010 32bit
Well, here's the less than elegant solution that I came up with: I typed something random in the third field. That then allowed me to go to a 4th field. Then I went back up and deleted the information in the third field. That created a 3rd field that was blank, which is what I needed.Originally Posted by pbaldy
Who is John Galt?
Windows XP Access 2007
Oh, I was thinking record; you did say field. In query design view you could have typed:
ThirdField: Null
or
ThirdField: ""
Competent Performer
Windows XP Access 2010 32bit
Well, maybe my solution wasn't so good after all because now the form isn't updating the table like it used to.
Who is John Galt?
Windows XP Access 2007
Changing the row source of a combo shouldn't affect that. Am I misunderstanding what you changed? Can you attach the db here?
Virtually Inert Person
Windows 10 Access 2016
Depending on what the rowsource is, you could probably just specify 1 more column than what you need.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Competent Performer
Windows XP Access 2010 32bit
I have the db file zipped, but cannot upload it. I've uploaded many zipped files to this forum before, but now it appears to no longer be working. Do I have too many files in my Access forum account?
Administrator
Windows 10 Access 2013 32bit
Is the .ZIP file =< 2 MB?
Posting Permissions
Reply With Quote