>Is there anyway to have a text box with a control source as a logical field but yet have a display value of "Yes" or "Y" when the control source value is True and a value of "No" or "N" when the control source is False ?

Yes, just put 'Y' into the InputMask property of the textbox.