UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> #size! Error, Access 2016    
 
   
Jdk412
post Oct 16 2019, 11:00 AM
Post#1



Posts: 97
Joined: 16-July 18
From: Detroit, MI


I have an unbound main form with multiple subforms I am trying to use a textbox on the main form that refers to the Primary key which is an auto number field on one of my subforms

=[PurchaseOrdersPOSF].[Form]![POID]

is my control source but it gives me a size error on my textbox

Any help would be appreciated thanks!
Go to the top of the page
 
arnelgp
post Oct 16 2019, 11:18 AM
Post#2



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


use Nz() function:

= Nz([PurchaseOrdersPOSF].[Form]![POID], "")

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
GroverParkGeorge
post Oct 16 2019, 11:33 AM
Post#3


UA Admin
Posts: 36,069
Joined: 20-June 02
From: Newcastle, WA


What is the datatype defined for that control?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
Jdk412
post Oct 16 2019, 11:57 AM
Post#4



Posts: 97
Joined: 16-July 18
From: Detroit, MI


It is an Autonumber Data Type

with adding NZ change it still returns the size error
This post has been edited by Jdk412: Oct 16 2019, 12:04 PM
Go to the top of the page
 
Jdk412
post Oct 16 2019, 12:07 PM
Post#5



Posts: 97
Joined: 16-July 18
From: Detroit, MI


Well, it magically worked itself out iconfused.gif

Thank you all for your quick responses!
This post has been edited by Jdk412: Oct 16 2019, 12:07 PM
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th November 2019 - 10:24 AM