Microsoft 365 access question


Summer02

Well-known member
Local time
10:50 AM
Posts
59
OS
Windows 11 Pro
Hi i am new to Access app i have setup a database of my book collection and i have a table setup ok
But when i create a from to add more data it opens wide right across the work area and i only want it to open the size of the form.
Also on my table i have a description of the book set to long text but on the form i only get a couple of lines visible
Can someone help please
 

My Computer My Computer

At a glance

Windows 11 Proi7-1065G7 CPU @ 1.30GHz 1.50 GHz16.0 GB
OS
Windows 11 Pro
Computer type
Laptop
Manufacturer/Model
HP Envy
CPU
i7-1065G7 CPU @ 1.30GHz 1.50 GHz
Memory
16.0 GB
Sorry no one has answered. I'm not a 365 user myself nor have I ever used Access so my suggestions of things to try are general since I'm flying by the seat of my pants .
Like with any app, you can resize the Access window to any size you want by dragging its edges. Windows will remember that size and open Access to that size every time unless you resize it.

When you create your table, once a field is created, as with other windows, at the top on the ID bar, hover your mouse over that field's divider bar. It should turn into a double ended arrow. Drag it to increase the amount of characters in that particular field so that the field is large enough to see your complete book description.

Hope I guess right.
 

My Computers My Computers

  • At a glance

    Windows 11 Pro 25H2 26200.8655i9-10900 10 core 20 threadsDELL 0J37VM32 gb
    OS
    Windows 11 Pro 25H2 26200.8655
    Computer type
    PC/Desktop
    Manufacturer/Model
    Dell Optiplex 7080
    CPU
    i9-10900 10 core 20 threads
    Motherboard
    DELL 0J37VM
    Memory
    32 gb
    Graphics Card(s)
    none-Intel UHD Graphics 630
    Sound Card
    Integrated Realtek
    Monitor(s) Displays
    Benq 27
    Screen Resolution
    2560x1440
    Hard Drives
    2x1tb Solidigm m.2 nvme /External drives 512gb Samsung m.2 sata+2tb Kingston m2.nvme
    PSU
    500w
    Case
    MT
    Cooling
    Dell Premium
    Keyboard
    Logitech wired
    Mouse
    Logitech wireless
    Internet Speed
    so slow I'm too embarrassed to tell
    Browser
    #1 Edge #2 Firefox
    Antivirus
    Defender+MWB Premium
  • Operating System
    Windows 11 Pro 24H2 26200.8457
    Computer type
    PC/Desktop
    Manufacturer/Model
    Beelink Mini PC SER5
    CPU
    AMD Ryzen 7 6800U
    Memory
    32 gb
    Graphics card(s)
    integrated
    Sound Card
    integrated
    Monitor(s) Displays
    Benq 27
    Screen Resolution
    2560x1440
    Hard Drives
    1TB Crucial nvme
    Keyboard
    Logitech wired
    Mouse
    Logitech wireless
    Internet Speed
    still too embarrassed to tell
    Browser
    Firefox
    Antivirus
    Defender
    Other Info
    System 3 is non compliant Dell 9020 i7-4770/24gb ram Win11 PRO 26200.8457
Hi i am new to Access app i have setup a database of my book collection and i have a table setup ok
But when i create a from to add more data it opens wide right across the work area and i only want it to open the size of the form.
Also on my table i have a description of the book set to long text but on the form i only get a couple of lines visible
Can someone help please
This is probably one of those you'll have to create a video to get someone to get what your issues is.

I'm afraid my Access skills aren't where they used to be as I've not used the app in ages. I have it, have a Database I created for my music collection, but haven't touched it in years.

Anyway, perhaps you can look elsewhere online. Perhaps some .edu (education) sites?
 

My Computers My Computers

  • At a glance

    Windows 11 Pro 24H2 (Build 26100.4770)Intel Core 9 Ultra 285KGigabyte Aorus Z890 Xtreme AI Top64G (4x16) DDR5 Corsair RGB Dominator Platinu...
    OS
    Windows 11 Pro 24H2 (Build 26100.4770)
    Computer type
    PC/Desktop
    Manufacturer/Model
    Custom built
    CPU
    Intel Core 9 Ultra 285K
    Motherboard
    Gigabyte Aorus Z890 Xtreme AI Top
    Memory
    64G (4x16) DDR5 Corsair RGB Dominator Platinum (6400Mhz)
    Graphics Card(s)
    Radeon (XFX Mercury) RX 9070XT OC (with Magnetic Fans)
    Sound Card
    Onboard (DTS:X® Ultra Audio: ESS ES9280A DAC)
    Monitor(s) Displays
    27-inch Eizo Color Edge - CG2700X
    Screen Resolution
    3840 x 2160
    Hard Drives
    4 Samsung NVM 990 Pro drives: 1TB (OS), 2TB, 2 X 4TB.
    PSU
    Seasonic TX-1300 (1300 Watts)
    Case
    Cooler Master H500M
    Cooling
    Corsair Link Titan 280 RX RGB
    Keyboard
    Logitech Craft
    Mouse
    Logitech MX Master 3S
    Internet Speed
    1TB Download. 512mb Upload
    Browser
    Microsoft Edge Chromium
    Antivirus
    Windows Security
    Other Info
    System used for gaming, photography, music, school.
  • Operating System
    Windows 11 Pro 24H2 (Build 26100.4061)
    Computer type
    PC/Desktop
    Manufacturer/Model
    Custom built
    CPU
    Intel Core i9-9900K
    Motherboard
    Gigabyte Z390 Aorus Xtreme
    Memory
    32gig (4 x 8) Corsair Dominator Platinum DDR4 3600Mhz (B-Die)
    Graphics card(s)
    Radeon XFX Merc 7900XT (20gig)
    Sound Card
    Onboard
    Monitor(s) Displays
    24-Inch NEC PA242W
    Screen Resolution
    2880 x 1800
    Hard Drives
    2 X NVME, 1 X SATA SSD
    PSU
    EVGA Super Nova 1000 P2 (1000 Watt)
    Case
    Phantek Enthoo Luxe
    Cooling
    Corsair H115i Elite AIO Cooler
    Keyboard
    Logitech Keys
    Mouse
    Logitech MX Master 3
    Internet Speed
    1TB Download. 512mb Upload
    Browser
    Microsoft Edge Chromium
    Antivirus
    Windows Security
    Other Info
    Backup System

My Computer My Computer

At a glance

Windows 11 Pro 25H2 (Build 26200.8728)Intel Core Ultra 9 285 5.6 GHz64-bit operating system, x64-based processor32.00 GB
OS
Windows 11 Pro 25H2 (Build 26200.8728)
Computer type
PC/Desktop
Manufacturer/Model
Dell Pro Max Tower T2 FCT2250
CPU
Intel Core Ultra 9 285 5.6 GHz
Motherboard
64-bit operating system, x64-based processor
Memory
32.00 GB
Graphics Card(s)
Intel Integrated Graphics (128 MB)
Sound Card
Realtek Audio
Monitor(s) Displays
Dell P2714H Monitor
Screen Resolution
1920 x 1080
Hard Drives
1 x 512GB M.2 XG10d SED KIOXIA PCIe solid state drive (Internal)
1 x 2TB Seagate ST2000DM008-2UB102 HDD (Internal)
1 x 1TB Seagate STGX4000400 External HDD
1 x 4TB Seagate STGX4000400 External HDD
1 x 6TB WD Elements AE 2689 External HDD
PSU
500 Watts
Cooling
Air
Keyboard
Microsoft Wired Keyboard 600
Mouse
Microsoft USB Basic Optical Mouse v2.0
Browser
Firefox
Antivirus
Windows Defender + Malwarebytes Premium
Other Info
BaseBoard Manufacturer Dell Inc.
BaseBoard Product 022RY57
BaseBoard Version A01
Back
Top Bottom