<div>
<a href="https://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101" rel="ugc">https://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101</a>
</div>


https://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101 [https://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101]

<div>
That should work for me. I really apreciate it!
</div>


That should work for me. I really apreciate it!

<div>
<div class="content wysiwyg-content">
Using the Application.Printers collection, I can get &nbsp;the Printers Bin number.<br />
I also found a way to get the bin descriptions using: &quot;Declare Function DeviceCapabilities Lib &quot;winspool.drv&quot;......&quot;<br />
<br />
But I need to get the currently selected printers default bin &quot;text&quot; (or description). <br />
<br />
For example &quot;Automatically Select&quot;,&quot;Manual Tray 1&quot;,&quot;Printer Autoselect&quot; etc... Depending on what is selected. <br />
In the image below, I want to get &quot;Tray 2&quot;, since it's been selected.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/02_w06/548292/RetrievePrinterTextImage.jpg" target="_blank" title="PrinterPropertiesDialogBox (18 KB)"><img alt="PrinterPropertiesDialogBox" class="file-block lazyload" style="max-width: 311px;" data-src="https://filedb.experts-exchange.com/incoming/2012/02_w06/548292/RetrievePrinterTextImage.jpg" /></a>
</div>
</div>


RetrievePrinterTextImage.jpg

Using the Application.Printers collection, I can get  the Printers Bin number.
I also found a way to get the bin descriptions using: "Declare Function DeviceCapabilities Lib "winspool.drv"......"

But I need to get the currently selected printers default bin "text" (or description). 

For example "Automatically Select","Manual Tray 1","Printer Autoselect" etc... Depending on what is selected. 
In the image below, I want to get "Tray 2", since it's been selected.



How do I Retrieve the 'Currently Selected Default' Paperbin description in VBA

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.

Microsoft Access

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.