Cambiar el tipo de control de un campo Boolean en Access si has elegido casilla antes.

Access tiene un comportamiento extraño en los campos de tipo Boolean cuando eliges el tipo de control casilla. En Access 2013 este control se pone por defecto (lo que lo hace más complicado) y en Access 2010 o 2016 pasa si escoges “casilla” y luego quieres volver a otro modo. No te deja volver a cambiar a Texto o Cuadro Combinado.

No parece que debiera ser así, si los valores los guarda como -1 (si/verdadero/casilla marcada) o 0 (no/falso/casilla desmarcada), debería dejar cambiar de uno a otro. Pero no es así.

Os enseñamos un truco con el que podéis poder volver a mostrar texto en vuestros campos Boolean.

 

Os recomendamos los siguientes productos relacionados con la informática:

 

Amazon Basics - MicroSDXC, 128 gb, con Adaptador SD, A2, U3, velocidad de lectura hasta 100 MB/s, Negro

(73060)

11,99 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

SanDisk 256GB Ultra Luxe Memoria flash, USB 3.2, con velocidades de transferencia hasta 400MB/s

(18814)

22,86 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Tenda Nova MW6 - Router Mesh WiFi Solución Completa WLAN de Malla de Doble Banda (2 Estaciones, 4 Puertos Gigabit, MU-MIMO, hasta 330 m²), Pack 2

(4583)

75,99 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

TP-Link Archer TX20E - Tarjeta Wi-Fi PCI Express Adaptador Wi-Fi 6 (AX1800) con Bluetooth 5.2, Compatible con Windows 11/10

(1290)

25,99 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

545 XL 546 XL Cartuchos de Tinta Compatible Cartucho Tinta para Canon 545 y 546 XL PG-545XL CL-546XL para Canon Pixma TS3150 TS3151 MG2550S MG2550 MG2950 TR4550 TR4551 MX495 (Negra y Color)

(26)

37,89 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

alptte Memoria USB 256GB USB 3.0 Pendrive Impermeable Pen Drive Metal Disco Duro Externo para Computadora Tableta, con Llavero (256gb)

(56)

15,99 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Repetidor WiFi Largo Alcance, Amplificador Señal WiFi 1200Mps 5GHz / 2,4GHz Dual-Band Anti-Jamming, Amplificador WiFi 4 Antenas, 2 Puertos LAN, Adecuado para Oficinas y Hogares, fácil de Configurar

(3)

34,99 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

HP 304 3JB05AE - Pack de 2 Cartuchos de Tinta Originales Negro y Tricolor, compatible con impresoras de inyección de tinta HP DeskJet 2620, 2630, 3720, 3730, 3750, 3760, HP Envy 5010, 5020, 5030

(192415)

23,70 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

SanDisk 1TB Extreme SSD portátil, USB-C USB 3.2 Gen 2 Memoria de estado sólido NVMe externa hasta 1050 MB/s Clasificación IP65 de resistencia al agua y al polvo

(81083)

104,99 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Beelink Mini S12 Pro Mini PC, Mini Ordenador de Sobremesa con Alder Lake-N N100, 16GB DDR4 +500GB M.2 PCIe 2280 NVMe SSD, WIFI6, Dual HDMI, Pantalla Dual, 1000Mbps, BT 5.2

(871)

199,00 € (a partir de 17 abril, 2024 13:14 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)