<div>
your sql that its based on, u create a row<br />
e.g.<br />
<br />
select top 1 '' as blankitem from sometable<br />
union all<br />
select field1 from sometable<br />
<br />
<br />
for each field u select, ensure that many rows are in the other query<br />

</div>


your sql that its based on, u create a row
e.g.

select top 1 '' as blankitem from sometable
union all
select field1 from sometable


for each field u select, ensure that many rows are in the other query


<div>
Jim,<br />
<br />
SELECT &quot;&quot;&nbsp;AS servco_no<br />
FROM dbo_service_company<br />
UNION SELECT servco_no<br />
FROM dbo_service_company<br />
<br />
gives me all values in table plus a blank at the top.<br />
<br />
Thanks!
</div>


Jim,

SELECT "" AS servco_no
FROM dbo_service_company
UNION SELECT servco_no
FROM dbo_service_company

gives me all values in table plus a blank at the top.

Thanks!

<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim<br />
<br />

</div>


Thanks for the grade.  Good luck with your project.  -Jim



<div>
<div class="content wysiwyg-content">
I would like a combo box which is based on a table with no blank values, to show a blank value as one of its choices.<br />

</div>
</div>


I would like a combo box which is based on a table with no blank values, to show a blank value as one of its choices.


Combo Box Blank Value Choice

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.