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 |
#11
|
|||
|
|||
Format display in a yes/no field
"J_Goddard via AccessMonster.com" u37558@uwe wrote in message
news:8164a9a78a28c@uwe... Hi - If you want to see the fiels as Yes/No in table view, to to table design. For the field you want to change, under the Lookup tab, set Display Control to Text Box, and under the General tab, set the format to Yes/No. These are for A2000, but should work in A2007 (not tested - I don't have A2007) John, His problem is that it displays properly, but when he clicks in the textbox to edit he gets the values -1 and 0. This is the behavior that cannot be changed. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
#12
|
|||
|
|||
Format display in a yes/no field
Arvin,
That is indeed my problem. One would have thought that when Microsoft's testers were taking it through the dev stages that it would have irritated them as much as it does me, and presumably many end users... "Arvin Meyer [MVP]" wrote: "J_Goddard via AccessMonster.com" u37558@uwe wrote in message news:8164a9a78a28c@uwe... Hi - If you want to see the fiels as Yes/No in table view, to to table design. For the field you want to change, under the Lookup tab, set Display Control to Text Box, and under the General tab, set the format to Yes/No. These are for A2000, but should work in A2007 (not tested - I don't have A2007) John, His problem is that it displays properly, but when he clicks in the textbox to edit he gets the values -1 and 0. This is the behavior that cannot be changed. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
#13
|
|||
|
|||
Format display in a yes/no field
You might try using a combobox with a ValueList:
0;No;-1;Yes That should display properly. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "efandango" wrote in message ... Arvin, That is indeed my problem. One would have thought that when Microsoft's testers were taking it through the dev stages that it would have irritated them as much as it does me, and presumably many end users... "Arvin Meyer [MVP]" wrote: "J_Goddard via AccessMonster.com" u37558@uwe wrote in message news:8164a9a78a28c@uwe... Hi - If you want to see the fiels as Yes/No in table view, to to table design. For the field you want to change, under the Lookup tab, set Display Control to Text Box, and under the General tab, set the format to Yes/No. These are for A2000, but should work in A2007 (not tested - I don't have A2007) John, His problem is that it displays properly, but when he clicks in the textbox to edit he gets the values -1 and 0. This is the behavior that cannot be changed. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
Field Format in Access for Image | Stephen | General Discussion | 0 | November 10th, 2004 08:44 PM |
Need help updating the "Display As" field | Joe Lombardo | Contacts | 2 | September 1st, 2004 09:41 PM |